Suggest on date Format

[priya945]

Hi All,

My date format is in below format, need to convert these into consistent format. Please suggest.

29 Apr

29 Apr

29 Apr

17 Apr

24 Apr

5/26/2018

5/26/2018

5/26/2018

5/26/2018

Thanks In Advance,

Priya

[Chanty4u]

Hi

i have created one document for this kind of requirments please have a look

Multiple Dates Using Alt

[Anil_Babu_Samineni]

Try this?

Alt(date(date#(field, 'DD MMM')), date(field))

[priya945]

Thanks to both of you.

Finally managed to get with below expression

Alt(Date([field],'M/DD/YYYY'),Date(Date#([field,'DD MMM'),'M/DD/YYYY')) as Date

[Anil_Babu_Samineni]

Great, You can mark your response as Correct Answer and you cal also do some helpful answers. FYI Qlik Community Tip: Marking Replies as Correct or Helpful