Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Days pending from date with time

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

11 Replies
satyadev_j
Specialist
Specialist

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

Not applicable
Author

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