topic Re: Date in QlikView

Date

Wed, 25 Nov 2020 16:16:04 GMT

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 — Wed, 06 Apr 2016 15:38:13 GMT

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 — Wed, 06 Apr 2016 17:58:16 GMT

Dear QlikView QV,

Please go through listed below article for date and time functions,

Kind regards,

Ishfaque Ahmed

Anonymous — Wed, 06 Apr 2016 18:06:01 GMT

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

Thu, 07 Apr 2016 05:34:36 GMT

Hi Experts i Got it

Thanks