topic Re: Different Date Formats in QlikView

Different Date Formats

Supplink — Sat, 16 Nov 2024 04:30:21 GMT

Ive been having this problem for months and I still can't fix it.

I export this info as text but for some reason Qlik changes the format to time stamp.

How can I convert it to a uniform date format ('DD/MM/YYYY'.)

Re: Different Date Formats

pradosh_thakur — Fri, 08 Feb 2019 19:54:15 GMT

date(floor(alt(timestamp#(Fecha_Stock,'DD/MM/YYYY hh:mm:ss'),date#(Fecha_Stock,'DD/MM/YYYY'))),'DD/MM/YYYY')

Re: Different Date Formats

rwunderlich — Fri, 08 Feb 2019 20:14:41 GMT

Hi @pradosh_thakur

I like the alt() approach to handle different formats. Though in this case I think you can get by with a single format and not use alt.

'DD/MM/YYYY[ hh:mm:ss]'

The [ ] indicate an optional portion.

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

Re: Different Date Formats

pradosh_thakur — Fri, 08 Feb 2019 20:26:23 GMT

Hi Rob,

I was not aware of this, so thank you for letting us know. I have learnt a lot from you and your posts. I hope that continues.

Thanks
Pradosh

Re: Different Date Formats

Supplink — Fri, 08 Feb 2019 20:47:02 GMT

Thanks A Alot!