 |
|
||||||||||
|
M.A.R.S |
||||||||||
|
This forum is for the sole use of MARS users. ChristianSteven Software will not accept any responsibility for the contents.
|
||
| Return to Website | ||
 First |
 Prev |
 Reply |
 Forum |
Next  |
Last  |
| Viewing Page 1 of 1 (Total Posts: 2) |
| Author | Comment |
Denise
Sep 15, 05 - 9:47 PM |
problem with date parameters
I want to schedule a report based on a query which is itself made of many other queries. All second level queries have a start / stop date parameter but the main query does not. How can I set those date parameters in M.A.R.S to be from current date to current date - 7 . Even discrete values will not work. Is there as pecial syntax to enter date parameters ? |
|
Mars Support
Sep 15th, 2005 - 10:08 PM |
Re: problem with date parameters
MARS will not see parameters in queries reffered from other queries. You should modify the secondary queries using e.g [DateField] >= Now()-7 and [DateField] <= Now() |
| First |
Prev |
Reply |
Forum |
Next |
Last |