I am trying to put in a different date than now() or default in a report in the parameter tab so that I can look at previous days data. What is the syntax for putting in a date in that field?
In the report editor, you would replace now()
with a desired datetime constant or explicit expression (like getDate()
).
At point of use, you would pass a desired datetime object in the parameters of the report.
So there is no way to put a date directly in the parameter at point of use? I would have to use a memory tag or something similar?
No, you don't need a tag. If using a report viewer, you can bind arbitrary UI properties to report parameters. (Like from a datetime entry component.) If using a script to generate the report, the script can populate the report parameters any way it likes.
I was able to do what I wanted from the getdate() command. thank you.