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)"
and next one is:
s = "{TEHTAVA.TEH_VALMIS_PVM} is between Date(2000, 6, 1)
and Date(2001, 6, 1)"
and third one is:
s = "{TEHTAVA.TEH_VALMIS_PVM} in Date(2000, 6, 1) to Date(2001, 6, 1)"
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 :]
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)"
and next one is:
s = "{TEHTAVA.TEH_VALMIS_PVM} is between Date(2000, 6, 1)
and Date(2001, 6, 1)"
and third one is:
s = "{TEHTAVA.TEH_VALMIS_PVM} in Date(2000, 6, 1) to Date(2001, 6, 1)"
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 :]