Member Avatar for swathys

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 !!!

  • 2 Contributors
  • 2 Replies
  • 111 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by swathys
Member Avatar for debasisdas

try this

If dr(DbaseExpiryDate) > Format(Now, "MM/DD/YYYYyyyy") Then
Member Avatar for swathys

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.