I have a date field. I use the string “#01-07-2007…03-07-2007|dd-MM-yyyy” to do the find. I want to find the date range but omit the time from the date range. But it returns no records.
If I use “#” for single date search then it works perfectly. “#03-07-2007|dd-MM-yyyy”
Please help!
Haven’t tried, but what happens if you do
"01-07-2007...03-07-2007|dd-MM-yyyy"
Couldn’t you also use
"01-07-2007 00:00:00...03-07-2007 23:59:59|dd-MM-yyyy HH:mm:ss"
Hi,
don’t use ‘#’ on a date range search (it’s just for single date search to ignore time). The range ignores the times & does 0:00:000 to 23:59.999 (or whatever…). you might need the | bit though, although if you have the pref. set for the date format and just use that in a range, it should work fine.
Thanks for your answer guys.
I am not sure why I posted this post. What rafig saying is actually working for me now.
Thanks!
I have the same problem, but not all the time. If I search ServiceDate with
"19-08-2007...20-08-2007|dd-MM-yyyy"
I get no records, but if I expand the search to
"19-08-2007...21-08-2007|dd-MM-yyyy"
I get 3 records with a ServiceDate of 20-08-2007.
I’m stumped.
as patrick said you can try this:
19-08-2007…20-08-2007
"19-08-2007 00:00:00...20-08-2007 23:59:59|dd-MM-yyyy HH:mm:ss"
There seems to be values in the time portion of the date 20-08-2007. So you may try the above.
Yep, you’re right, that does find the records. Thanks, missed that before. There’s the suggestion from rafig that a date range search ignores the time portion. This is the impression from the help files too.