Browse DevX
Sign up for e-mail newsletters from DevX

Tip of the Day
Language: VB
Expertise: Advanced
Feb 10, 2004



Building the Right Environment to Support AI, Machine Learning and Deep Learning

Determine the Value of a Date Variable

The value of a date variable is 12:00:00 AM when it is not assigned. If a date is optional for the user input, this value is often saved to the database when the user does not enter the date value. When you get this value from database and assign to a date variable, you usually need to determine if the value is entered by the user in order to show it properly. You can check if the value is equal to "12:00:00 AM." A more efficient way to use the following function:

Function IsEmptyDate(byval dt as Date) as Boolean
  Dim emptyDate as Date
  IsEmptyDate = dt = emptyDate
End Function
Guoran Xie
Thanks for your registration, follow us on our social networks to keep up-to-date