I created a date parameter for my command that I'd like to default to the current date. How can I do that?
I've done it with regular parameters (create as string & parse via a formula, then use the formula result in the record selection formula-I can detect a blank parm & set the formula to the current date) but can't figure out how to do it with this since the selection uses the parm itself.
It pretty much needs to be done this way because performance sucks entering the date via a regular parm. Even on the test database (2K records) it's poor and it's expected to be totally unsatisfactory on the whole db.
Thanks.Maybe I'm too impatient but with no responses yet I'm wondering if my question is unclear?
After more reading it appears that the obvious way of setting a default value derived from a formula would be to make the parameter dynamic-but there's no way to do that from the Command Parameter screen & when I change it from the regular Parameter screen it changes the type from Date to String.
I really like it as a Date type so users can select the date from the calendar-but I also need it able to default to the current date. Maybe those two things are incompatible-but I see no reason why they should be so, if that is the case, I'd like it confirmed before I tell my boss that it can't do both.
Thanks.|||Have you resolved defaulting to current date? I am trying to do the same thing and did not see any replies to your thread. Thank you
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment