sportsguy
Finance wiz, Access hack
- Local time
- Today, 17:58
- Joined
- Dec 28, 2004
- Messages
- 363
Good afternoon whereever you are in the world!
I have a linked table from a text file with a date time field.
When I open up the table to look at the data in the date time field, there are many date stamps, and a few #num!
I am wanting to trap the error and return null . . .
I have a linked table from a text file with a date time field.
When I open up the table to look at the data in the date time field, there are many date stamps, and a few #num!
I am wanting to trap the error and return null . . .
Code:
Function UploadTime(anyTime As Variant) As Date
If Str(anyTime) = "#Num!" Then
UploadTime= Null
Else
UploadTime= anyTime
End If
End Function