Skip to main content
  • EN

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.

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.

 

 

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

Not very hard to learn even.

Gives great control.

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?

 

 

Reply


Community Stats

30,194
Posts
114,615
Replies
37,857
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.