DateSerial

  • Thread starter Thread starter Mike Golla
  • Start date Start date
M

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?
 
Mike Golla said:
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?
Click to expand...

Please post the expression you are using.
 
It works fine for me with:

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