Timestamp formula including date and time formula

[dennisthemenace]

Hi all,

as written in the topic, I have created a Timestamp formula shown here:

Timestamp(Date('35645') &' '& Time('8/24'),'DD.MM.YY hh:mm')  

.. but the output is without time:

03.08.97 00:00

I have tried all possible things but without success.

Thanks in advance !!

[marcus_sommer · Accepted solution]

Try it with:

Timestamp(35645 + 8/24,'DD.MM.YY hh:mm')  

- Marcus

[dennisthemenace]

Thank you! its been working! 🙂