Hi,
Need to pull the date from >= first of the last month.
Below you can see an example,
Date> (DateTimeAdd(DateTimeAdd(DateTimeToday(),-1,"month"), 1-DateTimeDay(DateTimeAdd(DateTimeToday(),-1,"month")), "days"))
I tried with above formula its showing zero after the filter.
Hey @Ronal_bal ,
I've taken a slightly different approach and found the max date in your list and used that (hopefully I understood the requirement)
See my attached workflow to see if that works for you, what it's doing is:
- Finding the max date in the data
- Extracting the Month and Year
- Appending back to the main data
- Using those new fields to make sure our Year & Month are the same or greater than the max date
- Checking the day of our date is at least "1"
If this helps - please don't forget to accept it as a solution!
Hi @Ronal_bal
I think a formula like this in a filter tool would achieve what you want:
[Date] >= todate(DatetimeAdd(DateTimeFirstOfMonth(),-1,'months'))