Skip to main content
Question

DateTimeCalculator handling of minus numbers

  • March 12, 2020
  • 2 replies
  • 20 views
K
Forum|alt.badge.img

Hi,

 

I am trying to use the DateTimeCalculator on the calculate interval between two datetimes. The results I will get will be negative number as the date will be before the start date.

 

I am getting all the results rejected. Can the DateTimeCalculator output positive and negative numbers in the results?

 

Looking to use this for stats between two dates and if under and over the target date.

 

Thanks

 

Kevin

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

ebygomm
Influencer
Forum|alt.badge.img+44
  • ebygommInfluencer
  • Influencer
  • 3427 replies
  • March 12, 2020

Yes, it will output negative numbers if you ask it to calculate the difference between two dates where the end date is earlier than the start date.

Are you sure you have the dates correctly formatted?

K
Forum|alt.badge.img
  • kevinfrench
  • Author
  • 4 replies
  • March 13, 2020

Yes, it will output negative numbers if you ask it to calculate the difference between two dates where the end date is earlier than the start date.

Are you sure you have the dates correctly formatted?

Hi,

 

Thanks for the reply.

 

I will look at my data as there must be an issue with this then.

 

Thanks

 

Kevin

Community Stats

32,076
Posts
121,798
Replies
39,707
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.