Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Friends
I have field creation date coming from sharepoint. The date is captured in below format.
7/15/2014 3:01 PM
I have tried several formulas to subract it from today() in the script. But it is not working.
Please suggest the way around.
Thanks
Rahul
Hi,
So the date format changed to YYYY-MM-DD hh:mm:ss. Try below,
Interval(Now()-(Timestamp(Date#(ISSUE.Created, 'YYYY-MM-DD hh:mm:ss'))), 'DD') as Days_Pending
Thanks Sec were making the issue, now it is working again