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].

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