I have a database of some 6000 plus church burial records. These have been recorded as a date field for day and month (e.g. 22-Jan) and a second field for year (e.g 1775) All this data, plus data in a lot of other fields, is being transferred to a new program, for which the data needs to be in 4 fields - field 1 = date in the format of DD/MM/YYYY, field 2 = DD, field 3 = MM and field 4 = YYYY.

For starters I tried using search and replace to change all( for example) -Feb to /02, but that fails to find any. I also tried to convert the date fields to text but that resulted in dates such as 17-Feb becoming 43148. Once I get past this issue I hope that search and replace and concatenating will allow me to create the other filelds.

Any pointers as to how to achieve this?