Filter only the rows from previous months

[Rayyl]

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 solution]

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.

[Rayyl]

Thanks man!