Skip to main content
Question

DateTimeCalculator handling of minus numbers


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

2 replies

ebygomm
Influencer
Forum|alt.badge.img+33
  • Influencer
  • 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?


Forum|alt.badge.img
ebygomm wrote:

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


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