Error management in queries

[Lilian]

Hi everyone,

I'm in trouble with date functions Month().
I want to use it on a field that may contain a date yyyy-mm-dd or may be void.
My problem is that when I want to import the query result in an Excel sheet I get an error (impossible to access database). When I make a try on a database completely filled with date the importation is a success.

Do you have any idea about how to proceed ?

Thanks in advance !

[pbaldy]

How about this type of thing:

IIf(IsDate(FieldName), Month(FieldName), 0)

[Lilian]

Fantastic It works !

thanks

[pbaldy]

Happy to help, and welcome to the site by the way!