| Setting Dates as a Parameter [message #151816] |
Mon, 19 December 2005 06:14  |
orahugo
Messages: 32
Registered: October 2005
Location: England
|
Member |
|
|
Hello,
Is there a simple way of lists dates as a parameter? Then a user can select the date from the list.
If so, is there a way of making the default value the current date of the date the user is using it?
Many thanks in advance.
|
|
|
|
|
|
|
|
|
|
| Re: Setting Dates as a Parameter [message #153597 is a reply to message #153308] |
Tue, 03 January 2006 05:07  |
orahugo
Messages: 32
Registered: October 2005
Location: England
|
Member |
|
|
Thanks for your replies.
Firstly, I'm using 6i.
Anyway, the report is meant to run a check on our accounts. So basically we want to run it every day. There is one parameter (a drop down list) allowing you to choose the dates.
Therefore I'd like the date of the drop down list to display the date of the day being displayed by default.
I.e. if I was to run the report today, it'd say 3rd Jan, 2006.
However, I want the functionality to be able to run the report for days in the past, or days in the future.
Any ideas? Or will I have to hard code it?
I've done this sort of thing before where we select a week number, and the select statement for the parameter selects the week numbers from a table. I appreciate I could do the same for the dates, selecting the dates from the table with the accounts in, but I'd rather have a list of all the dates, not just the dates used in the table.
[Updated on: Tue, 03 January 2006 05:10] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
