Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
i have one field Received date data like,
12/18/2015 11:27:28 AM
12/22/2015 2:30:21 PM
12/22/2015 6:46:00 PM
12/24/2015 7:44:54 PM
here i want Current Date&Time(now())-(minus) Received Date.
i tried like this
now()-Received Date. but i am not getting correct.
Try this:
SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';
Table:
LOAD *,
Interval(Now() - [Received Date], 'D hh:mm:ss') as NewField;
LOAD * Inline [
Received Date
12/18/2015 11:27:28 AM
12/22/2015 2:30:21 PM
12/22/2015 6:46:00 PM
12/24/2015 7:44:54 PM
];
Note: There are two spaces between Date and Time components of your Received Date. So adjusted the SET statement for the two spaces.
Dear QlikView QV,
Please go through listed below article for date and time functions,
QLIKVIEW DATE FIELDS QlikView Technical Brief | Tania Quinatoa - Academia.edu
Kind regards,
Ishfaque Ahmed
Hi Let us know if you want in the same format how Sunny has explained.
Hi Experts i Got it
Thanks