AndrewJudd

Format Date to US in calculation

Discussion created by AndrewJudd on Oct 21, 2015
Latest reply on Oct 21, 2015 by 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

Outcomes