Filtering dates AFTER the 20th of the current month

[SnapperFlower]

Hello, 

What would the best approach be to identify/filter dates after the 20th of the current month. Data set will have dates into the following month also (snip attached)

[Yoshiro_Fujimori]

Hi @SnapperFlower ,

You can get the 20th of the current month with this expression, if the original date is cleansed to Date type.

Left([Date], 8) + "20"

Then you can simply use it to compare with the original date.

I hope this helps.

[SnapperFlower]

Thank you, I also have some data from prior months which will also need to be included as 'true' this formula.

Anything prior to the 20th of current month = true and anything after 20th of current month and into following month = false. The above formula isn't quite working for the June dates (or April)

[PangHC]

[date] < DateTimeAdd(DateTimeFirstOfMonth(),19,"day")

datatimefirstofmonth = 1st day of this month

+ 19 to 20th of the month

[Qiu]

@SnapperFlower 
@Yoshiro_Fujimori  and @PangHC should work I believe, but to give some details with a sample flow.

[SnapperFlower]

This worked, thank you. Much appreciated