Skip to main content
Question

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


4 replies

takashi
Influencer
  • 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
  • January 9, 2018
takashi wrote:

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
  • 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
Influencer
  • January 10, 2018
takashi wrote:

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?

 

 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings