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

      Hello,

       

      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.

       

      Problem:

      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

       

      R