By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,377 Members | 1,657 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,377 IT Pros & Developers. It's quick & easy.

Date criteria

P: n/a
Hi,

I need help, please...

I have a date field which I reformatted like this:
Sdate:Left([SessionDate],10). I then have a criteria on this field as
follows: Between #10/11/05# And #10/25/05#. My problem is that I am
getting records > than 10/25/05. What am I doing wrong?

Thanks,

Edgar

Dec 1 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Edgar wrote:
Hi,

I need help, please...

I have a date field which I reformatted like this:
Sdate:Left([SessionDate],10). I then have a criteria on this field as
follows: Between #10/11/05# And #10/25/05#. My problem is that I am
getting records > than 10/25/05. What am I doing wrong?

Thanks,

Edgar

You basically converted a date field into a string field. In a string
field, you'll get 1,10...19,100...199 then 2, 20...29, 200...299 if
sorting between 1 and 999.

Maybe filter on the dates. Either that, then filter/sort on records in
yyyymmdd format.
Dec 1 '05 #2

P: n/a
Salad,

Thanks for the insight. I changed the Sdate format to:
SDate:DateValue([SessionDate]). Now it's working.

Edgar

Dec 1 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.