Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Newbie question from query between two dates

Status
Not open for further replies.

Karibu

Programmer
Joined
Jul 26, 2001
Messages
5
Location
FI
I am making a database query, where I give starting date
and end date as parameters. The report should print the
result. For some reason, there appears no lines whatsoever
in my report, though formula syntax is right (no errors
appeared).

i have tried following formulas:

s = "{TEHTAVA.TEH_VALMIS_PVM} > Date(2000, 6, 1) and
{TEHTAVA.TEH_VALMIS_PVM} < Date(2001, 6, 1)&quot;

and next one is:

s = &quot;{TEHTAVA.TEH_VALMIS_PVM} is between Date(2000, 6, 1)
and Date(2001, 6, 1)&quot;

and third one is:

s = &quot;{TEHTAVA.TEH_VALMIS_PVM} in Date(2000, 6, 1) to Date(2001, 6, 1)&quot;

Report appears, but no data in it. Is there something I
miss? I searched other threads about this subject and found following formula:

date({RecDate}) in {?start-date} to {?end-date}

As you can see, third of my examples is like this, but what does question mark before 'start-date' means? I would appreciate any advise :]
 
No need to answer. I figured it out :)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top