Date range using setGenFilter 1

[mtastad]

I am having trouble using setGenFilter with date ranges. I have a TCursor opened on a table and am using setGenFilter to limit the view of the TCursor. I have searched through manuals and this site, but haven't found a solution. Any suggestions? Also, thank you to the people who responded to my previous post (very helpful)!!

 

[ros]

What kind of trouble are you having? Seeing nothing, seeing everything?
This kind of code should work:

daCrit[&quot;Date&quot;] = &quot;>12/31/2000, <2/1/2001&quot;
tc.setgenfilter(daCrit)

If this is what your date field filter looks like then you may have a problem in another field.
Post some code is still a problem,
Richie

 

[Guest_imported]

Any error messages to share?

I've found that when dates are involved, its best to ensure that the full four digits for the year are supplied. Be aware also of the order of the mm/dd or dd/mm if using the European date format. If the BDE and the PC regional setting are not all aligned correctly, order issues arise with some functions - e.g. they can work OK interactively for queries but not in code!

 

[ros]

mtstad,
FYI the most common reasons is see for problems in filtering or querying for date ranges are
1. Get No results :
a. There really are no matches (most common reason)
b. Mixing up >,< eg. &quot;<12/31/2001, >2/1/2002&quot;

2. Get Everything in table:
using OR instead of &quot;,&quot; eg. &quot;>12/31/2001 OR < 2/1/2002&quot;

Very rarely, but for the sake of completeness
3. Get Completely opposite of what you want :
combination of above eg. &quot;<12/31/2001 OR > 2/1/2002&quot;

Richie

 

[mtastad]

Thanks for the tips - here is the code I am using:

If not tcM.open(":ESI:Q_Main.db") then
	msginfo("Error","Unable to open TC on Q_Main")
	return
endif

criteria[&quot;Date&quot;] = &quot;> date(startDate.value), < date(endDate.value)&quot;

If not tcM.setGenfilter(criteria) then
	msginfo(&quot;Error&quot;,&quot;Unable to set date range&quot;)
	return
endif

startDate and endDate are undefined fields on the form (formatted as date fields). Dates are entered into them and the user clicks a &quot;calculate&quot; button to perform an operation based on the date range. The table &quot;Q_main&quot; has a date field called &quot;Date&quot;. When I execute the code, it doesn't get through the setGenfilter method (pops up the &quot;Unable to set date range&quot; message.

 

[Guest_imported]

Oh!
Try
criteria[&quot;Date&quot;] = &quot;> &quot; + string(date(startDate.value) + &quot;, < &quot; + string(date(endDate.value)

Otherwise, put a criteria.view() after setting criteria[...] and see what it says!