topic string to date & time in QlikView

string to date & time

Tue, 27 May 2014 11:56:42 GMT

Hello,

I have 2 field names with date and time as strings in my basic data as follows: Date 20130405, meaning 2013-April-05 and time as 2015 meaning 8:15pm.

I need to convert these to actual dates(yyyy-mm-dd) in qlikview script and preferably combine them to one field.. How would I do this?

Help much appreciated.

Regards,

Kevin

hic — Tue, 27 May 2014 11:59:34 GMT

Timestamp(Timestamp#(Date & ' ' & Time,'YYYYMMDD hhmm'),'YYYY-MM-DD hh:mm') as MyField

HIC

maxgro — Tue, 27 May 2014 12:05:46 GMT

in text box

=date(Date#('20130415', 'YYYYMMDD') + Time#('2015', 'hhmm'), 'yyyy-mm-dd hh:mm:ss')

in load

load

....,

yourdatefield,

yourtimefield,

date(Date#(yourdatefield, 'YYYYMMDD') + Time#(yourtimefield, 'hhmm'), 'yyyy-mm-dd hh:mm:ss') as newfield

......

from

its_anandrjs — Tue, 27 May 2014 12:09:34 GMT

You can try with the below script also

LOAD *,

Date(Date#(Date,'YYYYMMDD'),'YYYY-MM-DD') as NewDate,

Time(Time#(Time,'hhmm'),'hh:mm') as NewTime,

Date(Date#(Date,'YYYYMMDD'),'YYYY-MM-DD')& ' ' & Time(Time#(Time,'hhmm'),'hh:mm') as NewDateTime,

LOAD * Inline

[

Date,Time

20130405,2015

];

=============

And on front end on any text box write script like

=Date(Date#(20130415,'YYYYMMDD'),'YYYY-MM-DD') &' '& Time(time#(2015,'hhmm'),'hh:mm')

Tue, 27 May 2014 12:50:41 GMT

Thanks a bunch!

Tue, 27 May 2014 12:50:53 GMT

thanks!

Tue, 27 May 2014 12:51:03 GMT

thanks!