Filter for first of the last month dynamically

[Ronal_bal]

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.

[Nick-C]

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! 

[DavidP]

Hi @Ronal_bal 

I think a formula like this in a filter tool would achieve what you want:

[Date] >= todate(DatetimeAdd(DateTimeFirstOfMonth(),-1,'months'))

[binuacs]

@Ronal_bal one way of doing this