Hi
Dennis,
To set a VBA date variable to null, you can use the
"Empty" keyword. Here's an example:
Formula:
Dim myDate As Date
myDate = Empty
This will set the value of
"myDate" to null. You can then pass this variable to your SQL database without any issues.
- Declare a date variable "myDate" using the "Dim" keyword.
- Set the value of "myDate" to null using the "Empty" keyword.