How to change Date format

[Anonymous]

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

Thanks

[Anonymous]

use the code in script:

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

plz find the app attached.

[MarcoWedel · Accepted solution]

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]

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.