topic Re: datetime minus 1 sec issue in QlikView

datetime minus 1 sec issue

amien — Fri, 08 Apr 2016 20:19:14 GMT

I have this in a textbox:

=DATE(42397.3210243,'DD-MMM-YYYY HH:MM:SS')

This will give me : 28-JAN-2016 07:01:16 (great!)

Now 1 second less:

=DATE(42397.3210243- (1/(24*60*60)),'DD-MMM-YYYY HH:MM:SS')

This will give me : 28-JAN-2016 07:01:15 (great!)

Now 17 second less:

=DATE(42397.3210243- (17/(24*60*60)),'DD-MMM-YYYY HH:MM:SS')

This will give me : 28-JAN-2016 07:01:59 (Not good)

i would expect : 07:00:59 instead of 07:01:59

What i'm doing wrong?

sunny_talwar — Fri, 08 Apr 2016 20:37:29 GMT

Try this:

=DATE(42397.3210243- (17/(24*60*60)),'DD-MMM-YYYY hh:mm:ss')

MM is for Months

mm is for Minutes

You used MM for minutes as well

Fri, 08 Apr 2016 20:46:48 GMT

Your time format is wrong, As Sunny told use hh:mm:ss

Timestamp(42397.3210243- (17/(24*60*60)),'DD-MMM-YYYY hh:mm:ss')

I would prefar Timestamp instead of date function for understand purpose.

amien — Fri, 08 Apr 2016 21:03:43 GMT

Thanks Both