wafabekhti
Programmer
How do I compare 2 dates entered in a text box as mm/dd/yy to make sure that txtDate1.text < txtDate2.text ?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
compare dates
- Thread starter wafabekhti
- Start date
- Status
BiggerBrother
Technical User
if format(text1.text,"mm/dd/yy"
< format(text2.text,"mm/dd/yy" then
do something
else
end if
bb
< format(text2.text,"mm/dd/yy" thendo something
else
end if
bb
If CDate(txtDate1.text) < CDate(txtDate2.text) Then
BTW: If you can get your users to enter dates in ISO-8601 format, you can do a text compare, because the format naturally sorts:
YYYY-MM-DD
Chip H.
If you want to get the best response to a question, please check out FAQ222-2244 first
BTW: If you can get your users to enter dates in ISO-8601 format, you can do a text compare, because the format naturally sorts:
YYYY-MM-DD
Chip H.
If you want to get the best response to a question, please check out FAQ222-2244 first
- Status
Similar threads
- Locked
- Question
