Skip to main content
Solved

Date Category not applying to all entries

  • January 8, 2021
  • 2 replies
  • 14 views

joe.fme
Contributor
Forum|alt.badge.img+6

Hi all, I've been asked to do a pretty simple task, but it's giving me a bit of grief.

In simple terms, if a date is <= 31/12/2000, then it should be "Pre-2000", and anything >= 01/01/2000 it should be "Post-2000".

 

I've attached pictures to clarify, but this one is a real headscratcher

 

Any help is appreciated

Best answer by nielsgerrits

Convert the date (DateTimeConverter) to FME date (yyyymmdd) then use the conditional.

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.

2 replies

nielsgerrits
VIP
Forum|alt.badge.img+64
  • Best Answer
  • January 8, 2021

Convert the date (DateTimeConverter) to FME date (yyyymmdd) then use the conditional.


joe.fme
Contributor
Forum|alt.badge.img+6
  • Author
  • Contributor
  • January 8, 2021

Awesome! Thank you :)