5 Replies Latest reply: Nov 22, 2011 4:50 AM by Toni Kautto RSS

    Change date format in script from US to UK format



      I am trying to change the format of a US based excel spreadsheet from US to UK (i.e. from MM/DD/YYYY to DD/MM/YYYY) in the script. Whilst I can do it in the spreadsheet it isn't feasible as the data is updated on a daily basis. I know I can simply do the following expression in the script;


      Date(Date,'MM/DD/YYYY') as NewDate


      but it doesn't really fix the problem as I want to create a monthyear field from this as well and it won't work. Does anyone have any suggestions how to fix this in the script or otherwise?