Date Enteries as Words and not Number

[SteveC2007]

How can i display the actual month names and years in a dropdown selection box in Crystal. Currently when A user selects a date it in a calandar form. Can anyone help this is pretty urgent!

 

[PatriciaObreja]

Create a parameter of type string, set default values for it, and enter manually the values: January, ... and do the same for years.

-----------------------------------------------------------------------------------------------------------------------------
"Now I can look at you in peace; I don't eat you any more." Franz Kafka, while admiring fish in an aquarium

 

[kskid]

I agree with PatriciaObreja. However, if you are using the parameters as date in your record selection, then you will have more work to do

You need to create a formula to translate the string months into a month number

//MonthNo
Select {?Monthparm}

Case "January":
1
Case "February":
2
Case "March":
3
.
.
.
Case "December":
12

If you are selecting records based on month and year then

{table.datefield} in [dateserial({?YearParm},@MonthNo,1) to dateserial({?YearParm},@MonthNo + 1,1-1)]

-lw