Remove or Filter out current month

[PassION_es]

Hi,

I simply want to remove rows with current month.

I currently have this formula. 

[Risk Date]<=DateTimeNow()

What else do I  need to add from the DateTimeNow?

Thanks

[IraWatt · Accepted solution]

Hey @PassION_es,

Try in a filter tool:

[Risk Date]<=DateTimeTrim(DateTimeNow(),"firstofmonth")

Datetime trim can convert a date to the start or end of a month

Or you can try:

DateTimeMonth([Risk Date])<=DateTimeMonth(DateTimeNow())

Date time month returns the month of a date as a number

[PassION_es]

Thanks @IraWatt

[IraWatt]

No worries @PassION_es !