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
Try this in a Formula tool: ToDate(DateTimeTrim(DateTimeAdd(DateTimeNow(),-1,"months"),"lastofmonth"))
Chris
You can use the following
datetimeadd(datetimetrim(DateTimeParse([Date],'%m/%d/%y'),'firstofmonth'),-1,'day')
@ilovecoding
another formula for doing this
datetimeadd(datetimetrim(DateTimeParse([Field1],'%m/%d/%y'), 'month'), -1, 'day')
hope this helps.