Date function errors

[jduenyas]

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 · Accepted solution]

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

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

[jduenyas]

You are a genius!

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