Give both the dates you are using the same format,
that way you can really compare them.

with vb

if FormatDateTime(yourDate, theformat) >
FormatDateTime (now(), theformat) then
yourerrormessagegoeshere
else
yourcontinueoptions go here
end if

--- Guerrino Di Minno <GDiMinno@h...> wrote:
> Hi to all...
> 
> I'm writing a function that check the date
> validation.
> I got everything to work, but now I want to write a if statement that 
> checks to see if its today's date or greater and if it is error message 
> appears, if its not then it will just continue. 
> 
> But I cannot get it...
> 
> Can someone please help me with this...
> 
> Thanking you in advance.
> 
> Gino