End of month/days in a month

[yvwo1]

Is there a relatively simply way to count the number of days there are in this month. Last month WITHOUT hardcoding the month in. What I am going to do is take the number of days in the month, subtract the number of days already past, add the number of days left and multiply the data to do some projections.

Thanks!

 

[bdreed35]

This will get you the last day of the previous month:

Maximum(LastFullMonth)

Use the Day function to get the number of days

Day(Maximum(LastFullMonth))

If you need days remaining in the month, than you could do something like this:

DateDiff("d", CurrentDate, DateAdd("m",1,DateAdd("d",-(Day(CurrentDate)-1), CurrentDate))-1)

~Brian

 

[yvwo1]

Works like a charm! Slick! Thank you