topic Re: Date and Time Stamp Question in QlikView

Date and Time Stamp Question

Tue, 22 Dec 2015 11:36:46 GMT

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

Re: Date and Time Stamp Question

Chanty4u — Tue, 22 Dec 2015 12:41:30 GMT

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

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

for time

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

Re: Date and Time Stamp Question

Tue, 22 Dec 2015 12:50:31 GMT

Hey Suresh,

Thanks for your reply.

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

Re: Date and Time Stamp Question

vcanale — Tue, 22 Dec 2015 13:04:55 GMT

Hi,

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

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

Regards

Re: Date and Time Stamp Question

Chanty4u — Tue, 22 Dec 2015 13:09:48 GMT

hi.,

PFA

Re: Date and Time Stamp Question

PradeepReddy — Tue, 22 Dec 2015 13:11:20 GMT

try like this..

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

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

Re: Date and Time Stamp Question

sunny_talwar — Tue, 22 Dec 2015 13:19:03 GMT

Try this:

Date

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

Time

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