Reply
Highlighted
Member
Posts: 45
Registered: ‎08-06-2018
Accepted Solution

adding duration to date

 Hello community.

 

I have a table with one field that is number of days  in it (decimal). I want to add this to a calendar date (01/01/1970).  I have researched all options and am doing something wrong as each effort results in an error.

 

As close as I have been able to get is

[T1] = 17905.72715   This is the number of days since 01/01/1970

 

Date.AddDays(DateTime.FromText("1970-01-01"),[T1])

 

The error returned is "Expression Error: The number is out of range of a 32 bit integer value.  Details: 17905.72715

 

Thanks for advice.

 

Regards

 

Jim B

 


Accepted Solutions
Frequent Visitor
Posts: 16
Registered: ‎05-15-2018

Re: adding duration to date

[ Edited ]

Try changing [T1] to Duration and then simply use + to add DateTime.FromText("1970-01-01") and [T1].Untitled.png

View solution in original post


All Replies
Frequent Visitor
Posts: 16
Registered: ‎05-15-2018

Re: adding duration to date

Try changing [T1] to a Whole Number. DateAdd expects a whole number, and not a decimal.

Member
Posts: 45
Registered: ‎08-06-2018

Re: adding duration to date

Is there another function that will accept decimal values?  The resulting value would represent intraday prices and eliminating the decimal portion would result in an inaccurate value.

Frequent Visitor
Posts: 16
Registered: ‎05-15-2018

Re: adding duration to date

[ Edited ]

Try changing [T1] to Duration and then simply use + to add DateTime.FromText("1970-01-01") and [T1].Untitled.png

Member
Posts: 45
Registered: ‎08-06-2018

Re: adding duration to date

Thanks very much.  It works.

 

I just have to adjust for time zone and I have the total solution.

 

Jim B