Need to retain the datetime

[timsaddler]

My OTD_Actual_Leave_Date is 41720.427083333

I am using the following code to convert back to a datetime.

Date(OTD_Actual_Leave_Date)&'-'&Time(OTD_Actual_Leave_Date)

Is there a more efficient way ?

thanks

[#2]

I believe the timestamp function can convert that value into a date time format, so I would try timestamp(OTD_Actual_Leave_Date).

[MK_QSL]

Try below in Text Box..

=Today()

Now Try below in Text Box..

=Timestamp(Today())

..... 🙂

=Timestamp(OTD_Actual_Leave_Date)

[#4 · Accepted solution]

Hi Tim,

Try This one also work,

=timestamp(OTD_Actual_Leave_Date, 'YYYY-MM-DD hh:mm:ss' ) or

=date(OTD_Actual_Leave_Date, 'YYYY-MM-DD hh:mm:ss' )

[#5]

Hi Tim,

Use timestamp(OTD_Actual_Leave_Date, 'YYYY-MM-DD hh:mm:ss')