Filter only the rows from previous months

Question

Hello everyone,

Is there a specific solution (without creating a new column) that allows you to only get the rows that match a date in previous months? So for example, in September it's practical for August and before. Thanks in advance!

Best regards,
Christian

DataNath · Accepted Answer

Hey @Rayyl, you can handle this with a Filter tool with an expression like the following:

DateTimeMonth([Input]) < 
DateTimeMonth(DateTimeToday())

Just replace [Input] with your own date field.