Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Anonymous
Not applicable
Author

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 - Contributor II
Partner - Contributor II

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.