adding duration to date

[JimB-GA]

 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

 

[tarunsingla]

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

[JimB-GA]

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.

[tarunsingla · Accepted solution]

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

[JimB-GA]

Thanks very much.  It works.

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

Jim B