When concatenating dates into a SQL string, you must use a standard US date format, regardless of t

by Anonymous (267 Submissions)
Category: Miscellaneous
Compatability: Visual Basic 4.0 (32-bit)
Difficulty: Unknown Difficulty
Originally Published: Sat 15^th May 1999
Date Added: Mon 8^th 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

Rate When concatenating dates into a SQL string, you must use a standard US date format, regardless of t



         If Not IsDate(x) Then Exit Function
         MakeUSDate = "#" & Month(x) & "/" & Day(x) & "/" & Year(x) & "#"
   End Function

Download this snippet Add to My Saved Code

When concatenating dates into a SQL string, you must use a standard US date format, regardless of t Comments

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.

When concatenating dates into a SQL string, you must use a standard US date format, regardless of t

When concatenating dates into a SQL string, you must use a standard US date format, regardless of t Comments

Post your comment

Difficulty