DateSerial

[Mike Golla]

When using the DateSerial function to generate the last
day of the month, If in the month of October it will
generate erroneous month and year values but the correct
day value. For all other months it generates properly.
Has anyone seen this error and is there a fix for it?

 

[Rick Brandt]

When using the DateSerial function to generate the last
day of the month, If in the month of October it will
generate erroneous month and year values but the correct
day value. For all other months it generates properly.
Has anyone seen this error and is there a fix for it?

Please post the expression you are using.

 

[Van T. Dinh]

It works fine for me with:

?DateSerial(Year(Date()), Month(Date()) + 1, 0)
31/10/2003