Selecting last date of the prior month

[ilovecoding]

Lets say every month i have 2 months in dataset. Today is 2nd May, how can i filter last day of previous month from column Date. Note, this data changes every month, so example in Jun, i'll have column for May as prior month and Jun as current month and i have to select last day of May.

Date

04/02/24

04/08/24

04/20/24

04/30/24

05/01/24

05/02/24

[ChrisTX]

Try this in a Formula tool:  ToDate(DateTimeTrim(DateTimeAdd(DateTimeNow(),-1,"months"),"lastofmonth"))

 

 

Chris

[cjaneczko]

You can use the following

datetimeadd(datetimetrim(DateTimeParse([Date],'%m/%d/%y'),'firstofmonth'),-1,'day')

[Raj]

@ilovecoding 
another formula for doing this

datetimeadd(datetimetrim(DateTimeParse([Field1],'%m/%d/%y'), 'month'), -1, 'day')

hope this helps.