Were these values entered into a text field or a field of type date?
If these are valid dates entered into a date field, you can use the data formatting options at the bottom of the inspector's data tab to specify a date format and all dates will then display with the same format even though they were entered differently.
Thanks, but the data is being exported out and causing me issues when trying to format it via an XSLT template. I'd like to be able to tidy up the existing data as part of my next release, so trying to figure out if it can be done. The data has already been input via a text field which has the correct format, but users seem to have been able to input dates in the varying formats without any issue.
And that would be because:
The data has already been input via a text field
Dates should be entered into date fields, not text fields to ensure that valid dates are entered and to better be able to work with them as dates once they are entered. This would also make for simpler data export.
I suggest defining a calculation field with this expression and a "date" result type:
GetAsDate ( YourTextFieldHere )
Then export from this date field. The date formats should now be consistent. This also allows you to do much simpler formatting calculations if you need a specific format for your exported data as you now have a date so you can use things like the month, year, monthname, dayname functions to extract different pieces of the date field.
Let ( d = GetAsDate ( YourTextFieldHere ) ;
Dayname ( d ) & ", " & MonthName ( d ) & " " & Day ( d ) & ", " & Year ( d )
To produce output such as: Wednesday, May 6, 2015
Just to give an example of how much simpler this is once you have cast your data as date instead of text.