Validating Date of Non-Date Data Type

[loisk]

Hi,

I need to compare a date (on a form )entered by a user with today's date and a date should not be greater than today. The problem, however, the data type for the date is string, not date date type. Is there anyway that I can test the user-entered-date against today's date? Thanks!

[missinglinq]

You can use the CDate() function

Private Sub YourTextDate_AfterUpdate()
If CDate(Me.YourTextDate) > Date Then
  MsgBox "Date must be  " & Date & "  or earlier!"
End If
End Sub
 

Of course, one has to ask why you don't simply change the datatype to Date/Time?

Linq ;0)>

[loisk]

You can use the CDate() function

Private Sub YourTextDate_AfterUpdate()
If CDate(Me.YourTextDate) > Date Then
  MsgBox "Date must be  " & Date & "  or earlier!"
End If
End Sub
 

Of course, one has to ask why you don't simply change the datatype to Date/Time?

Linq ;0)>

Thank you so much!
The data types of my db are given to me by my boss.

[missinglinq]

Shows how much he knows! You have my sympathy!

Linq ;0)>

[loisk]

Shows how much he knows! You have my sympathy!

Linq ;0)>

Hi, Linq!

I think that he tries to avoid any other conflicts by having string date type.

Anyway,
it works fine until it gets deleted and left blank. Then I get an error warning, "Invalid use of Null." Any help on this. I appreciate!