I have a form with soem feilds. One feild holds a date in the format of 20041231 Now i want a message box if this feilds is less than the current month. So its december now if any dat falls before december than i want a alert message box, Here is some code i tried but not working. DO i have to format some dates my formatt is 20041231
If Text133 < Now() Then
MsgBox "Please enter a value!", vbOKOnly, "Invalid Search Criterion!"