Last Date of the Month function (1 Viewer)

[thehallclan]

I searched for this on all of the forums, but I didn't see where it was posted already...

I need a function to return what the last date is for a particular month. It needs to be really efficient (Not a Month - 1 calculation) since I am going to be using it in code that runs through a huge amount of data.

Any help is greatly appreciated...

 

[Sohaila Taravati]

Group your query and choose Last, then sort Descending. Then in the critaria put Like 7/*/*, which will show you the last date in the month of July or however you want to set critaria

 

[Pat Hartman]

The last day of the current month:
DateSerial(Year(Date()), Month(Date()) + 1, 0)

Replace Date() with YourDate to find the last day of a specific month