Skip to main content
  • EN

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

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?

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

Reply


Community Stats

30,176
Posts
114,543
Replies
37,835
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.