Date Difference

[smilingjohn]

Hi All,

Please find the attachment of the QVW file . I have to shows total number of days taken to close the ID And the formula is like EndDate-StartDate I tired using NUm(EndDate)-num(StartDate) but this is not giving me any result . and also in another table i have to display the same table with different expression which is like NUm(EndDate)-num(StartDate) / count(StartDate) Can please someone help me on this???

Thanks in Advance

[sunny_talwar]

Change this in the script's environmental variable

SET TimestampFormat='DD-MM-YYYY h.mm.ss';

[Brett_Bleess]

John, did Sunny's post get you what you needed?  If so, please be sure to use the Accept as Solution button on his post to give him credit and let others know it worked.  If you are still trying to get things working, leave us an update.

Regards,
Brett