DateSerial Function

[Mike Golla]

When using the DateSerial function to generate the last
day of the month, if you are in the month of October it
generates erroneous data. For all other months it
generates the last day of the month. Has anyone else seen
this issue and is there a fix?

 

[Wayne Morgan]

I just tried it and it seems to work fine, you'll need to show us the equation you are
using.

 

[Douglas J. Steele]

I've never heard of that problem before.

What's the exact code you're using to generate the problem?

 

[Van T. Dinh]

See answer in later thread.

Please do not create multiple threads on the same question.