Last Date of the Month function

[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