Date and Time Stamp Question

[#1]

Hi All,

I am new to qlikview. I am stuck at a point and need your help. Really sorry that I cant share the complete data and dashboard because of the security concerns.

I have Timestamp in the format "20151216091842" and now I need to split this into two parts, First 8 digits ad Date, and rest of the digits as Time i.e 20151216 as Date and 091842 as Time.

Thanks a lot for your help,

Prasant Tata

[Chanty4u]

=Date(Floor(Timestamp#('20151216091842','MMDDYYYY  hhmmss TT')))

or

=Date(Floor(Timestamp#(YourTimeStampFieldName,'MM/DD/YYYY  h:mm:ss TT')))

for time

=Time(Frac(Timestamp#(YourTimeStampFieldName,'MM/DD/YYYY  h:mm:ss TT')))

[#3]

Hey Suresh,

Thanks for your reply.

I tried this but it didnt workout. Attaching the sample application.

[vcanale]

Hi,

Try:
=Date( Date#(Left('20151216091842',8), 'YYYYMMDD'), 'YYYY-MM-DD')     //-->Date

=Time( Time#(Right('20151216091842',6), 'hhmmss'), 'hh:mm:ss')     //-->Time

Regards

[Chanty4u · Accepted solution]

hi.,

PFA

[PradeepReddy]

try like this..

=date(Timestamp#(timestamp_field,'YYYYMMDDhhmmss'))

=time(Timestamp#(timestamp_field,'YYYYMMDDhhmmss'))

[sunny_talwar]

Try this:

Date

=Date(Floor(Timestamp#(TimeStamp,'YYYYMMDDhhmmss')))

Time

=Time(Frac(Timestamp#(TimeStamp,'YYYYMMDDhhmmss')))