I've run into the following problem:
Suppose you've got a DTPicker control called dtpDate on your form set to 01/12/2014 (dd/mm/yyyy format). The following code returns False!
Format(dtpDate,"dd/mm/yyyy") >= Format(Date,"dd/mm/yyyy")
I'm running VB6/SP2 on NTWS/SP5 - my clock is set to 24-jun-1999. Isn't this strange behaviour, certainly when the following line does return True as it should:
CDate(Format(dtpDate,"dd/mm/yyyy")) >= Format(Date,"dd/mm/yyyy")
But - and this is the clue:
IsDate(Format(dtpDate,"dd/mm/yyyy")) returns True
TypeName(dtpDate.Value) returns Date
Conclusion: I *HAVE* to use explicite Date types ????
Has anyone seen this before?