topic Need to retain the datetime in QlikView

Need to retain the datetime

timsaddler — Wed, 26 Mar 2014 16:46:47 GMT

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

Wed, 26 Mar 2014 16:51:36 GMT

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 — Wed, 26 Mar 2014 17:02:20 GMT

Try below in Text Box..

=Today()

Now Try below in Text Box..

=Timestamp(Today())

..... 🙂

=Timestamp(OTD_Actual_Leave_Date)

Thu, 27 Mar 2014 05:31:14 GMT

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' )

Thu, 27 Mar 2014 05:50:41 GMT

Hi Tim,

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