Convert string Aug,31 2020 into date 31/09/2020

[ankur13agrawal]

I have a column with filed name as Start_date which is varchar type and date is in format Aug,31 2020 and i want to convert it into Date format 31/09/2020.

Currently when i am trying month(start_date) i am getting no result as qlik is not able to identify column as a date..so its not able to give me the expected output

Help is appreciated

[Anil_Babu_Samineni]

Perhaps this

=Date(Date#('Aug,31 2020', 'MMM,DD YYYY'))

[ankur13agrawal]

Thanks
This is working for a particular date...i have multiple date under start_date column.i need all the value to get converted

[Anil_Babu_Samineni]

You can still do

=Date(Date#(FieldName, 'MMM,DD YYYY'))

If you have multiple dates in different format you should write like this

Date(Alt(Date#(FieldName, 'MMM,DD YYYY'), Date#(FieldName, 'MMM DD YYYY'), Date#(FieldName, 'MMM -DD YYYY'), Date#(FieldName, 'MM/DD/YYYY'), ...))

[ankur13agrawal]

Date(Date#("START_DATE", 'MMM,DD YYYY')) as ankur,
Tried this but ankur is coming as -

I have only one format but many values

Aug,31 2020

May,20,2019

[ankur13agrawal]

Correction

May,20 2019

[Anil_Babu_Samineni]

Image or file please to check?

[ankur13agrawal]

Note-Start_date field is set as varchar from the source

[Anil_Babu_Samineni · Accepted solution]

You should place correct format in the first step otherwise we need to spend lot of time to know, Anyway this should work since your format is MMM DD, YYYY but not MMM, DD YYYY

Date(Date#("START_DATE", 'MMM DD, YYYY')) as ankur,

[ankur13agrawal]

thanks a lot!!
for correcting my mistake..it worked