Different Date Formats

[Supplink]

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'.) 

 

[pradosh_thakur · Accepted solution]

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

[rwunderlich · Accepted solution]

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

[pradosh_thakur]

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

[Supplink]

Thanks A Alot!