Validate textbox control date with variable date

Hi

Can you explain exactly what you want to know? Do you want to validate a date variable or are you talking about a variable date?

For example I have an TextBox can only accept date format as yyyy -mm -dd so how I can validate the date value in text box with date stored in variable with type Date

OK, you can compare dates just using the = , for example

if txtDate = cdate("2011-10-08") then print "Dates Match"

or possibly, to make sure there is a date in the text box (I have called it txtDate):

if isdate(txtDate) then
    if txtDate = cdate("2011-10-08") then print "Dates Match"
end if

or to see if the date entered in the textbox is earlier than today:

if isdate(txtDate) then
    if txtDate < now then print "Date is earlier than " & now
end if

I will check the all answers

This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.