Skip to main content
Question

How To compare two Date fields in a record, that too in fme 13

  • January 8, 2018
  • 4 replies
  • 125 views

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.

4 replies

takashi
Celebrity
  • 7843 replies
  • January 8, 2018

Hi @vioarx, if the date values are formatted with FME standard date format (%Y%m%d), you can compare them as numeric values using comparison operators such as <, <=, etc.


  • Author
  • 5 replies
  • January 9, 2018

Hi @vioarx, if the date values are formatted with FME standard date format (%Y%m%d), you can compare them as numeric values using comparison operators such as <, <=, etc.

I tried it, but when comparing in such a way the result is not convincing. I have checked for greater value and it gives result for both greater value and equal value.

 

 


gio
Contributor
Forum|alt.badge.img+15
  • Contributor
  • 2252 replies
  • January 9, 2018

I mostly prefer to use tcl clock, format etc. to do date calculations.

Not very hard to learn even.

Gives great control.


takashi
Celebrity
  • 7843 replies
  • January 10, 2018

Hi @vioarx, if the date values are formatted with FME standard date format (%Y%m%d), you can compare them as numeric values using comparison operators such as <, <=, etc.

Do you mean, for example, "20171201 < 20180131" and "20171201 = 20180131" both pass the test?

 

Could you please post some example pairs of two dates to be compared?