topic How to change Date format in QlikView

How to change Date format

Anonymous — Thu, 10 Sep 2015 22:36:21 GMT

How to change Date format from 10-SEP-15 to 9/10/2015 in the back end ?

Thanks

Re: How to change Date format

Anonymous — Thu, 10 Sep 2015 23:20:09 GMT

use the code in script:

Date(Date#(Date,'DD-MMM-YYYY'), 'M/D/YY') as Date1

plz find the app attached.

Re: How to change Date format

MarcoWedel — Thu, 10 Sep 2015 23:40:41 GMT

Date(Date#(yourdatefield,'DD-MMM-YY'),'M/D/YYYY') as yourdatefield

and make sure your MonthNames variable is set correctly to interpret the month names.

regards

Marco

Re: How to change Date format

palexandrou — Thu, 13 Jan 2022 14:17:21 GMT

In case you wanted to keep both formats and you would like to change between them, you could set a variable vtest='dateformat'; in the script and in the front end you could create a text box and set this variable with value 0 and value 1 depend the format you want to displayed each time.