AnsweredAssumed Answered

Consistent date formatting

Question asked by davehob on Jan 18, 2017
Latest reply on Jan 20, 2017 by philmodjunk

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:

  1. Replace field contents on all dates, using a calculation Substitute ( Self  ; ["-";"/"] ; [".";"/"] ),
  2. 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?

 

Thanks,

 

Dave.

Outcomes