Problem Comparing Dates

  • Thread starter Thread starter Eddy
  • Start date Start date
E

Eddy

I am using the code below to compare dates. The first date comes from a
query supplying data to a combo box. The second comes from a table through
the query underlying the form itself. When I pause the code the value for
the first date is 12/12/2003 and the second is 9/13/04 yet this code returns
True. Both fields are Date/Time data types in there respective tables.
Thanks for the help.

Field1.Column(49) > Me!EntDate
 
You could force the compare to use date logic like this:
CDate(Field1.Column(49)) >CDate( Me!EntDate)

HTH
- Turtle
 
Back
Top