topic Re: date from timestamp in string format in QlikView

date from timestamp in string format

Fri, 17 Jul 2015 05:15:17 GMT

how to fetch date from timestamp in string format

PFA for the same

phaneendra_kunc — Fri, 17 Jul 2015 05:16:52 GMT

You can write Date(Your_Field, 'MM/DD/YYYY')

MayilVahanan — Fri, 17 Jul 2015 05:20:43 GMT

Try like this

Date(Date#(FieldName, 'MM-DD-YYYY HH:mm'),'MM-DD-YYYY')

tresB — Fri, 17 Jul 2015 05:21:06 GMT

Date(Floor(Date#(Field, 'DD-MM-YYYY hh:mm'))) as Date

qlikmsg4u — Fri, 17 Jul 2015 05:21:17 GMT

Use this in script

Date(Floor(Timestamp#(YourDateField,'MM-DD-YYYY hh:mm')),'MMM-DD-YYYY') as Date

Ex Output: Nov-03-2000

dionverbeke — Fri, 17 Jul 2015 05:21:56 GMT

Hi,

If you wrap a date around a timestamp you can have duplicate dates in a listbox.

It is best practices to split the datetimestamp in two fields:

date(subfield(timestamp,' ',1)) as date_timestamp

and time(subfield(timestamp,' ',2)) as time_timestamp

Kind Regards,

Dion

maxgro — Fri, 17 Jul 2015 05:55:04 GMT

LOAD

@1 as Source,

Floor(Date#(@1,'MM-DD-YYYY hh:mm')) as DateNum,

Date(Floor(Date#(@1,'MM-DD-YYYY hh:mm'))) as Date,

Frac(Date#(@1,'MM-DD-YYYY hh:mm')) as TimeNum,

Time(Frac(Date#(@1,'MM-DD-YYYY hh:mm'))) as Time

FROM

timestamp.xls

(biff, no labels, table is Sheet1$);