Does anyone know if you can format a date field to US and keep that formatting when it goes into a calculation?
You can see the issue in the attached.
Format the date field from the inspector, under data formatting on the data tab. The default is "As-enter", change it to the desire format.
Thanks, yes but in calculation fields?
Sorry, if the date was the only item in the calculation field as type date then the inspector would work.
You may have to use merge fields to get the desired results.
or create a calculation or custom function that converts the date to US format by switching the month and day.
Retrieving data ...