Skip to main content
Solved

Is there a straightforward way to filter date/time attribute by a set period?

  • October 27, 2020
  • 3 replies
  • 858 views

I have a 10-year-long dataset that needs to be split by year. The complication in my case is that I need each output year to start from December of the preceding year, i.e. the output filter for year 2019 has to be from 01/12/2018 00:00 to 01/01/2020 00:00. I can't seem to get this to work with AttributeRangeFilter.

Cheers.

Best answer by ebygomm

I presume you've converted your dates to FME formats and are using that syntax in the AttributeRangeFilter?

 

Personally, I'd probably add a month to each date and then get the year and then filter by that single value.

 

 

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

3 replies

ebygomm
Influencer
Forum|alt.badge.img+44
  • Influencer
  • 3434 replies
  • Best Answer
  • October 27, 2020

I presume you've converted your dates to FME formats and are using that syntax in the AttributeRangeFilter?

 

Personally, I'd probably add a month to each date and then get the year and then filter by that single value.

 

 


david_r
Celebrity
  • 8394 replies
  • October 27, 2020

I presume you've converted your dates to FME formats and are using that syntax in the AttributeRangeFilter?

 

Personally, I'd probably add a month to each date and then get the year and then filter by that single value.

 

 

I was just going to suggest the same thing. Keep it simple.


  • Author
  • 2 replies
  • October 27, 2020

That's it! I have converted the original date/time from mm/dd/yy to dd/mm/yyyy, but have not used the FME format.

Everything works like a charm now, thank you muchly!