topic Re: Suggest on date Format in QlikView

Suggest on date Format

priya945 — Wed, 25 Nov 2020 16:16:04 GMT

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 — Mon, 02 Jul 2018 15:40:21 GMT

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

Anil_Babu_Samineni — Tue, 03 Jul 2018 01:26:48 GMT

Try this?

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

priya945 — Tue, 03 Jul 2018 10:12:06 GMT

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 — Tue, 03 Jul 2018 13:34:55 GMT

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