Selecting last date of the prior month

Question

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

Raj · Answer

@ilovecoding 
another formula for doing this

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

hope this helps.

cjaneczko · Answer

You can use the following

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

ChrisTX · Answer

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

Chris