VBA Form Validation

[WickidWe]

Hi,

The code below is to check on a form whether the From Date is Less than the To Date.
For some Reason it is not coming up with the error

If Format(Me.txtFromDate, "dd/mm/YYYY") < Format(Me.txtToDate, "dd/mm/YYYY") Then
 MsgBox "'Between Dated' must be more than Start Date!", vbExclamation
    Exit Sub
    Else

Im sure it has something to do with the fomatting of the date but I cant figure it out.

I tried the same code with a ">" instead and it worked although it shouldnt. but only if the dates where in the same year.
Strange......



Any Ideas?

[WickidWe]

No Matter....
I Had the < around the wrong way

[RuralGuy]

The Format function always turns the results into a string. Try just comparing the controls by themselves.

[WickidWe]

thats the ticket....Thanks

[June7]

Format results in a text string and alpha sort rules. This means "23/12/2012" is not less than "21/12/2013".

Either don't use Format and compare true date values or use "YYYYMMDD"

[RuralGuy]

Glad we could help.