Hi ,
I have two date start date and end date , and i want time duration in days but the problem is data is coming from task report .
a!gridTextColumn( label:"Start Date", field:"c6", data:index(local!dataset.data,"c3",{}) ),
and
a!gridTextColumn( label:"End Date", field:"c8", data:index(local!dataset.data,"c11",{})
),
i need one more column which shows the duration of time for these two date .
please suggest
Discussion posts and replies are publicly visible
What have you tried so far / what exactly is the problem you're having?
i want subtract start date and end date ... to get time in duration .... is it possible
Jun 9, 2019 11:34 AM start date
Aug 6, 2019 11:34 AM end date
I tried this:
datetime(2011, 12, 13, 12, 0, 0) - datetime(2011, 12, 10, 10, 0, 0)
in one of the example boxes, and this was the result:
It's Interval format, 3 days and 2 hours. So the - (minus) operator should take care of it.
Let us know if you have further problems.