Calculate the date for the last day of the previous month

[Bill_misc_IT]

I'm looking for a simple calculation for the date of the last day of the previous month, based on Get(CurrentDate)?

I can use month(get(CurrentDate)-1, but wondered if there is an easy way to calculate this, other than a complex calculation for the day, based on 28, 29, 30, 31 days in the given months?

Thanks,

 

Bill

[comment]

8 minutes ago, Bill_misc_IT said:

wondered if there is an easy way to calculate this

Here's one:

Let ( 
today = Get ( CurrentDate )
;
today - Day ( today )
)

Here's another:

Let ( 
today = Get ( CurrentDate )
;
Date ( Month ( today ) ; 0 ; Year ( today ) )
)

 

[Bill_misc_IT]

That's what I was looking for.  Day "0" goes back to last day of previous month...got it.