by Anonymous (267 Submissions)
Category: Miscellaneous
Compatability: Visual Basic 4.0 (32-bit)
Difficulty: Unknown Difficulty
Originally Published: Sat 15th May 1999
Date Added: Mon 8th February 2021
Rating: (1 Votes)
When concatenating dates into a SQL string, you must use a standard US date format, regardless of the Regional Settings in Control Panel. This
If Not IsDate(x) Then Exit Function
MakeUSDate = "#" & Month(x) & "/" & Day(x) & "/" & Year(x) & "#"
End Function
No comments have been posted about When concatenating dates into a SQL string, you must use a standard US date format, regardless of t. Why not be the first to post a comment about When concatenating dates into a SQL string, you must use a standard US date format, regardless of t.