DayofWeek convert from numerals 2/3/4etc to Mon/Tues/etc

[Kmccormic]

Good Afternoon:

I'm using a cascading parameter prompt. I've set up the following script:
DayOfWeek ({iCDNStat.Timestamp}) in 2 to 6 and
{iCDNStat.Timestamp} = {?Enter Date Range} and
DayofWeek ({iCDNStat.Timestamp}) = {?Day of Week #}

This {?Enter Date Range} allows me to enter a range of dates to limit my report by. I also wanted to limit the report by day of week, all mondays, all tuesdays, etc. {?Day of Week #} allows me to choose a specific value, 2-6. How can I change the script above to allow me to choose a day of week by word rather than choosing a number in my parameter prompt?

Thank you for your advice.
Kara

 

[lbass]

You don't need the first line if you use the last one. For your dayofweek parameter, in the parameter setup screen, add the number as the value and then add the text as the description field. Then set "show description field only" to true. You would leave your selection formula as is (without the first line).

-LB

 

[Kmccormic]

Thank you LBass, that works.