Days pending from date with time

[#1]

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

[Anonymous]

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

[#3]

Thanks Sec were making the issue, now it is working again