Forum Discussion

JimB-GA's avatar
JimB-GA
Icon for Helper III rankHelper III
7 years ago
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 ...
Need Help
Tutorial Requests
  • tarunsingla's avatar
    tarunsingla
    7 years ago

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

JimB-GA's avatar
JimB-GA
Icon for Helper III rankHelper III
7 years ago

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's avatar
tarunsingla
Icon for Solution Sage rankSolution Sage
7 years ago

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

  • JimB-GA's avatar
    JimB-GA
    Icon for Helper III rankHelper III
    7 years ago

    Thanks very much.  It works.

     

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

     

    Jim B