Date

[#1]

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.

[sunny_talwar]

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.

[engishfaque]

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

[Anonymous]

Hi Let us know if you want in the same format how Sunny has explained.

[#5]

Hi Experts i Got it

Thanks