Hi. I'm new to this forum and relatively new to Access and VBA. I am extracting data from a table where all the date fields are numeric like 20160101. The field that I'm concerned with [TermDate] has 99999999 as a future date if the TermDate has yet to be determined or an actual numeric date like 20160101 if a Term Date exists. I'm trying to convert my date fields to actual Date formats. I would like to write a query that would do something like this:
If the [TermDate] is equal to 99999999 Then change/update that date/value to #12/31/9999# Else change the numeric value to an actual date format. I'm using CDate(Left([rnchdt],4) & "/" & Mid([rnchdt],5,2) & "/" & Right([rnchdt],2)) to convert to the date format.
Thanks for any assistance in advance!