Suggest on date Format - Qlik Community

priya945 · ‎2018-06-30

Hi All,

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

29 Apr

17 Apr

24 Apr

5/26/2018

Thanks In Advance,

Priya

Chanty4u · ‎2018-07-02

Hi

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

Multiple Dates Using Alt

Anil_Babu_Samineni · ‎2018-07-02

Try this?

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

priya945 · ‎2018-07-03

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 · ‎2018-07-03

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful