I have a vendor database that I need to Query using Access. Their date fields are formatted as follows. "1061025" in their D/B where 1=constant value in every date,06=year,10=month,25=day. Is there a way to convert this to a normal mm/dd/yy format with SQL? Thanks for any help and suggestions.
I would just use the following:
Assuming sVar = "1061025" use the follwing
mid(sVar,4,2) & "/" & left(sVar,2) & "/" & mid(sVar,2,2)
=
10/25/06
however this would be a string,
but in sql must convert it to date, therefore use cdate(sVar)