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

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 ) )
)

 

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