topic how to convert string into date in QlikView

how to convert string into date

sunil1989 — Wed, 22 Mar 2017 11:56:30 GMT

Hi ,

Thanks in advance!!!!!!

i am new to qlik.

i am delevrey date field whose data type is string and the value in that field is '2017-03-08 20:08:05 UTC'.

how should i convert this into numeric and then convert into date with timestamp.

vvvvvvizard — Wed, 22 Mar 2017 12:01:02 GMT

=Date(Date#(Subfield( DeliveryDate,' ' ,1),'YYYY-MM-DD'),'YY-MMM-DD')

Where i have YY-MMM-DD , put any format which you want the output to be displayed in .

Where i have YY-MM-DD , thats the format to tekk qlikview to read in the data

Subfields is to remove the data before the space

Anil_Babu_Samineni — Wed, 22 Mar 2017 12:05:41 GMT

What are you expecting to see by given? Can you provide more values

awhitfield — Wed, 22 Mar 2017 12:14:00 GMT

Hi there,

you say numeric, but what do you actually expect to see as the output?

Andy

vvvvvvizard — Wed, 22 Mar 2017 12:18:13 GMT

=Date(Date#(Subfield( DeliveryDate,' ' ,1),'YYYY-MM-DD'),'YY-MMM-DD')

I missed a space before the 1

neha_shirsath — Wed, 22 Mar 2017 12:18:14 GMT

Hi,

Use below expression-

=Date(Date#(subfield('2017-03-08 20:08:05 UTC','UTC'),'YYYY-MM-DD hh:mm:ss'),'DD/MM/YYYY')

Thanks,

Neha