G
Guest
Hi,
I was wondering if anyone could help me??
I am trying to convert a field in my db from a text field to a date field
using the following expression:
CDate(format([warre],"Short Date")). The date is currently stored as 060401
but when i run the query with the above expression in I get an output of
14/05/65.
Please help!!
Many thanks.
I was wondering if anyone could help me??
I am trying to convert a field in my db from a text field to a date field
using the following expression:
CDate(format([warre],"Short Date")). The date is currently stored as 060401
but when i run the query with the above expression in I get an output of
14/05/65.
Please help!!
Many thanks.