Date Comparison 1

[iamedwardkim]

Hi,

I am trying to compare a date in a table to a date in a text box on a form. I have a feeling it's because the two dates may not be of the same data type. Any ideas?

 

[KenReay]

Hi

So what is going wrong?

If problem is data type have you tried CDate() as in (say) CDate(txtDate)? Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK

 

[iamedwardkim]

Yes, the DLookup criteria has been set to:

"[PayRateEffDate] = " & CDate(Me.DateWorked).

 

[KenReay]

Hi

Are you in the UK, or at least outside of USA?

If yes, it may be you have to quote the date in US format (eg mm/dd/yy) and bound it in #..#

I never use DLookup, so I cannot be sure about its possible quirks Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK

 

[iamedwardkim]

I'm actually in the U.S. Thank for your help.

 

[iamedwardkim]

Bounding the string date in #'s worked. Thank you again.