Using Access2K.
The data imported into a table looks like this...
White| |Greg|20oct2002|
I used a query and parsed it into individual fields using formats simular to the one below.
WEDate: Left$([WEDate2],InStr([WEDate2],"|")-1)
After parsing, parsing and parsing again.
I now have 3 fields...
White and Greg and 20oct2002
The problem now, is that the date is in text format.
How can I make the query read this field as a date?
Thanks in advance,
The data imported into a table looks like this...
White| |Greg|20oct2002|
I used a query and parsed it into individual fields using formats simular to the one below.
WEDate: Left$([WEDate2],InStr([WEDate2],"|")-1)
After parsing, parsing and parsing again.
I now have 3 fields...
White and Greg and 20oct2002
The problem now, is that the date is in text format.
How can I make the query read this field as a date?
Thanks in advance,