Forum Discussion
Helper IIIadding 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
Try changing [T1] to Duration and then simply use + to add DateTime.FromText("1970-01-01") and [T1].
4 Replies
- tarunsingla
Solution Sage
Try changing [T1] to a Whole Number. DateAdd expects a whole number, and not a decimal.
JimB-GAIs 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
Try changing [T1] to Duration and then simply use + to add DateTime.FromText("1970-01-01") and [T1].