topic Date function errors in QlikView

Date function errors

jduenyas — Wed, 25 Nov 2020 16:16:04 GMT

Hi all

I have just discovered some anomaly:

In a text box convert a date like 2016-12-26 08:08:08 (or any date you wish) to numerical value:

NUM('2016-12-26 08:08:08') the result in this date sample will be 42730.338981481

now either in the same text box or a new one convert the result to date:

DATE(42730.338981481,'YYYY-MM-DD HH:MM:SS') and the result will not be the same but rather 2016-12-26 08:12:08

Any idea why?

Thanks

sunny_talwar — Thu, 29 Dec 2016 19:08:29 GMT

You need to use mm for minutes and not MM (MM is for months)

DATE(42730.338981481,'YYYY-MM-DD HH:mm:SS')

jduenyas — Thu, 29 Dec 2016 19:16:20 GMT

You are a genius!

Thanks. How did I not think of it...