Dates that are not the last day of the month

[Guest]

Hi:

I need help with a query. I have a date field in my db and I need to
identify dates that are not the last day of the month.

Thanks

 

[Guest]

You could use a WHERE clause that looks something like:

WHERE DAY(DateAdd("d", 1, [DateField])) > 1

 

[Guest]

It worked. Thanks so much for your help.

You could use a WHERE clause that looks something like:

WHERE DAY(DateAdd("d", 1, [DateField])) > 1

--
Email address is not valid.
Please reply to newsgroup only.

Hi:

I need help with a query. I have a date field in my db and I need to
identify dates that are not the last day of the month.

Thanks

 

[John W. Vinson]

Hi:

I need help with a query. I have a date field in my db and I need to
identify dates that are not the last day of the month.

Thanks

Try a criterion on Datefield of

<> DateSerial(Year([datefield]), Month([datefield]) + 1, 0)


John W. Vinson [MVP]