Help required with dbase date format

admin

Administrator
Staff member
Hi

Unfortunately, I'm very green on this!

I've got several dbase files which have dates in one field ("whenseen") in
various formats ie:

07/88
7/9/88
12/12/00

I'd like to standardise everything to become dd/mm/yyyy ie:

12/12/2000

Obviously, the dates with no day info will have to become something like:

00/07/1988

Can anyone offer any code which will do this without too much effort?

Many thanks in advance


Bill Robertson
 
Back
Top