UPDATE query

J

John Thomas

I want to create an UPDATE query that updates a table that
has a text field that contains dates in the following
format:

From:DDMMYY
To:YYYYMMDD

How can I do this if

OP CMDS is my table
CensusDate is my field
Also the CensusDate field may have blank fields.
 
Top