5 Replies Latest reply on Oct 21, 2015 10:39 AM by AndrewJudd

    Format Date to US in calculation

    AndrewJudd

      Hi all, I'm trying to format a calcualtion field with a US style date (can't be done with Inspector).

      I am trying to attached custom format with the below calculation however it seems to think mon-dd-yy is a field. I have tried mm-dd-yy but the same result.

       

      Any ideas where I'm going wrong? thanks!

       

       

       

       

      _MatchExhibitionTitle & ¶ &

       

      _MatchExhibitionLocation & ¶ &

       

      date.format ( _MatchExhibitionStartDate ; mon-dd-yy )

       

      & ¶ &

       

      _MatchExhibitionEndDate & ¶ &

       

      _MatchExhibitionCity & ¶

       

       

       

      Screen Shot 2015-10-21 at 18.17.08.png