hi,

this is my code
If dr(DbaseExpiryDate) > Format(Now, "M/dd/yyyy") Then

id i run this code it gives error with
IndexOutOfRangeException was Unhandlled

this is the output of the date
DbaseExpiryDate= 3/31/2011
now= 3/24/2011


Please guide me....whats wrong even i have format the date it doesn't work at all....
Please Help Me !!!

try this

If dr(DbaseExpiryDate) > Format(Now, "MM/DD/YYYYyyyy") Then

hi,

ok i got it...it's not wrong wt the way i format the date...its working well after i do like this If DbaseExpiryDate < Format(Now, "M/dd/yyyy") Then