Discussion Board for collaboration related to QlikView App Development.
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.
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