how to convert string into date

[sunil1989]

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]

=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]

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

[awhitfield]

Hi there,

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

Andy

[vvvvvvizard]

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

I missed a space before the 1

[neha_shirsath]

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