RE:Date format Issue

[Chanty4u]

Hi all,

input date format

column name: Voice_date

Data is in below format for Voice_date

August 31, 2015 9:00:00 PM IST

February 13, 2015 4:30:00 PM IST

September 6, 2015 5:00:00 AM IST

Required format output

YYYYMMDD

Thanks in advance

Best

Chanty

[Kushal_Chawda]

try this

TO_DATE(TO_CHAR(SUBSTR(Date,1, length(Date)-4),'MONTH DD, YYYY HH:MI:SS AM'),'YYYYMMDD')

[Chanty4u]

Thanks for response.

But its not in Qlikview it is Qliksense

[Chanty4u]

Raj...

its givng error.

[tamilarasu]

What is the error messge  you are getting.?