Start Free Trial
Come for the solution, stay for everything else.
Start Free Trial
What formula can I add to the date field, so end user can either select data via the calendar or the shortcut key such as T-1, M-1 etc???
Thanks in advance.
8/22/2022 - Mon
I appreciate this might just be me, but I have no idea what Crystal feature you are referring to by..
"the shortcut key such as T-1, M-1 etc"
There is no way to do that. Crystal date prompts expect a date to be entered. There are no shortcut keys to choose a date.
If you have CR2008 you can have optional prompts. You could use a date for 1 and a string for another then evaluate appropriately.
I assume T-1 is yesterday and M-1 is last month
Yes, I do have CR2008. Do you have any sample for using the string?
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Do you just want to use those specific strings, "T-1" and "M-1"? If so, what do they mean?
Or do you want to allow something more general, like "T-X", where "X" could be different numbers? If so, exactly what do you want to allow?
Producing yesterday's date when a parameter is "T-1" is easy. Actually checking the value after the "-" and producing a date based on that is more complicated.
I would like to have:
T-"num" = today's day - num of days user enter.
T+"Num" = today's day + num of days user enter.
M-"num" = Current Month - num of month user enter.
M+"Num" = Current Month + num of month user enter.
Y-"num" = Current year - num of year user enter.
Y+"Num" = Current year + num of year user enter.
Also user should able enter what ever day they want on the beginning date and ending date field. Or select the date from the default calendar.
As stated above, the only way to get the calendar is to use a DATE or DATETIME parameter. It will only accept valid dates.
You can add a second parameter as a string and they can enter whatever they want.
I will try to get an example put together.
to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
An example will be great. Thank you so much!!!
ASKER CERTIFIED SOLUTION
Log in or sign up to see answer
Become an EE member today
7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Plans and Pricing
Certified Expert Program
© 1996-2022 Experts Exchange, LLC. All rights reserved. Covered by US Patent