i am trying to compare a start date and end date in a access db using the db field to db field comparison. what i want to do is when the start date matches the end date just show the start date. here is the code that is on the page

<% if (rsEvents.Fields.Item("StartDate".Value != rsEvents.Fields.Item("EndDate".Value) { %>
- <%= DoDateTime((rsEvents.Fields.Item("EndDate".Value), 1, 2057) %>
<% } // if (rsEvents.Fields.Item("StartDate".Value != rsEvents.Fields.Item("EndDate".Value) %>

... i think i have done it right, but for some reason it is failing the condition.

please post CR2 questions in appropriate place.
www.udzone.com/forum/default.asp?NewsId=628
it keeps the knowledge in one place, easier if Waldo decides to make a CR2 FAQ.

With kind regards,

Dennis van Galen
Webmaster KPN Nederland
Financial and Information Services