AnsweredAssumed Answered

Reformat Existing Date Column

Question asked by ManjitSandhu on May 6, 2015
Latest reply on May 6, 2015 by philmodjunk


Reformat Existing Date Column


I'm having some issues with my reports because the data has not been correctly validated to ensure users enter dates in a consistent format. So the current data is in a mix of blanks (allowed), DD/MM/YYYY, D/M/YYYY, DD/M/YYYY, D/MM/YYYY and also DD.MM.YYYY. What I'd like to do is reformat all existing dates in one hit, rather than open each record and update according.

Is there a way to, say, run a function on all entries that does something like:

Right( "0" & Day( cDate); 2 ) & "/"
Right( "0" & Month( cDate ); 2 ) & "/"

Year ( cDate ) &