I have a mixture of date formats in an application - some dates are shown as 'dd/mm/yyyy', others as 'dd-mm-yyyy'. I want them all to be 'dd/mm/yyy', so what I'm proposing to do is:
- Replace field contents on all dates, using a calculation Substitute ( Self ; ["-";"/"] ; [".";"/"] ),
- Specify the same format under Data Formatting for each of the fields on every layout.
This will be tedious, but no big deal. But is there an easier way to achieve this? And is there a better practice for keeping consistency?