[2005] Getting rid of a repeat?

[techgnome]

your diagnose of the problem is spot on... the problem arises because NOW() includes the time, down to the milisecond.... what you should be comparing is the date portion. Because even if you set it to a date, it won't have the time, so it assumes midnight, which is less than Now() (which is the current date time) and you get the message.

try this:

If Ffrom.Value < System.Data.Date.Today Then

I think that's the right namespace path.....

-tg

[mutasim]

your diagnose of the problem is spot on... the problem arises because NOW() includes the time, down to the milisecond.... what you should be comparing is the date portion. Because even if you set it to a date, it won't have the time, so it assumes midnight, which is less than Now() (which is the current date time) and you get the message.

try this:

If Ffrom.Value < System.Data.Date.Today Then

I think that's the right namespace path.....

-tg

It says 'Date' is not a member of 'Data'. and it doesn't solve it. Thanks for trying though. After reading your post i tried,

now.date()

and this still doesn't solve it.

Thanks,

Mutasim