Skip to main content

Hi All,

I have tried to implement several suggestions from the community regarding date filtering; however, I have not been successful so far. I am trying to filter dates in a CSV file based on the "last login" within the past three months. The date format in the file is as follows:

  • 18/07/2025 09:16
  • 08/07/2025 12:46
  • 01/02/2024 10:07
  • 16/01/2025 10:33

I have converted those dates to %Y%m%d resulting ‘20230403’ then add an AttributeManager to change the ‘last_loging’ attribute to ‘date’ and finally used the following expression to filter the "last login" within the past three months:

@Evaluate(@DateTimeFormat(@DateTimeSubtract(@DateTimeNow(), '3', 'months'), '%Y%m%d'))

...but for some reason doesn’t work,

Any guidance or support would be greatly appreciated.

I think I have found the correct expression :)

@DateTimeAdd(@DateTimeNow(),-P3M)

Thanks


Reply