Converting a String of Numbers to Date in a function

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

Your code works but I still have an error. When the people in our office input data, it's done in the order mm/dd/yyyy, but as you know from the example it's done in a text field. When looking at incomplete documentation, sometimes it is missing the day or the month. If it is, they will enter 99 in iplace of the missing data.

For instance, if we know the month, but not the day, we will enter 12992004 which would convert to 12/99/2004, but the error is coming up because it's not a real date.

How could I get it to output the number 99 (instead of the date) if either the month or the date is the number 99??

You can not show 99 or 9999 in a date variable. How are you planning to show it on the web page, if 99 or 9999 comes ?
The only way out I see, is to change the data type from DATE to STRING in the webpage, and since in the database this field is STRING, you don't even have to change it to Date format.
Just use:
Function CHECKLMPDATE(var1 as String) as String
If (var1 & DbNull.Value) <> "" Then
var1 = var1.Substring(0, 2) & "/" & var1.Substring(2, 2) & "/" & var1.Substring(4)
Return var1
Else
Return ""
End If
*** In this case you HAVE to keep that field as STRING in the page.

... or, store the individual fields separately and combine them on the fly to a text format. If a field is unknown, just leave it empty and in the output set it to "XX"

However, if you want to process dates (with sorting etc.), you could also modify the format to YYYYMMDD. If a part is unkown, set it to 99 or XX. Store them as strings. This way, you can at least sort for them without messing up the results (the MMDDYYYY format will not be sortable if stored as string).

... addition to my previous post: "MMDDYYYY format will not ne sortable" - of course you can sort using this format, but the results are not sorted by Year, Month and Day but by Month, Year and Day. Usually, you do not want this. So, it may be better to save a string in the YYYYMMDD format which sorts correctly and, if a day is unknown, will still sort correctly.

This tutorial demonstrates one way to create an application that runs without any Forms but still has a GUI presence via an Icon in the System Tray.
The magic lies in Inheriting from the ApplicationContext Class and passing that to Application.Ru…

The ECB site provides FX rates for major currencies since its inception in 1999 in the form of an XML feed. The files have the following format (reducted for brevity)
(CODE)
There are three files available HERE (http://www.ecb.europa.eu/stats/exch…

Planning to migrate your EDB file(s) to a new or an existing Outlook PST file?
This video will guide you how to convert EDB file(s) to PST. Besides this, it also describes, how one can easily search any item(s) from multiple folders or mailboxes…