Forum Discussion
Solved
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 ...
Try changing [T1] to Duration and then simply use + to add DateTime.FromText("1970-01-01") and [T1].
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.
Try changing [T1] to Duration and then simply use + to add DateTime.FromText("1970-01-01") and [T1].
Thanks very much. It works.
I just have to adjust for time zone and I have the total solution.
Jim B