3 Replies Latest reply on Feb 2, 2018 9:52 AM by Michael Ye

    Changing US to UK date formats in calculated fields

    Roberto Angelucci



      I am wondering if someone can assist in this simple task.


      I have a field that comes in as text and I can convert this into the date using DATEPARSE("MM/dd/YY",[Field 1])

      I then need to find the date difference between today and the Field 1.


      Here is the problem. The Field comes in as a US formatted date, I am in the UK and if I use the TODAY() function it comes in as UK format dd/MM/YY.



      How do I either

      1) change the Field 1 from a US date format to a UK date format or

      2) change the Today() result into a US date format?


      Thank you very much