Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
qlikdash
Specialist
Specialist

How to change Date format

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

Thanks

1 Solution

Accepted Solutions
MarcoWedel

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

View solution in original post

3 Replies
qlikrajan
Creator III
Creator III

use the code in script:

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


plz find the app attached.

MarcoWedel

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

palexandrou
Partner
Partner

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.