Converting a String of Numbers to Date in a function
Posted on 2004-09-21
I have a field in my Access database that is type text, and I need to convert it to type date programatically within the function as I have 17,000 fields and changing each field individually is not an option.
The text in the database looks like 12312003, and I would like to change it on the webpage to date type 12/31/2003
My function looks like this (var1 is the string to convert):
Function CHECKLMPDATE(var1 as object) as String
Return (format(var1, "MM/DD/YY")).ToString
The code above gives me errors. What is the correct syntax??