Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Date Enteries as Words and not Number

Status
Not open for further replies.

SteveC2007

IS-IT--Management
Oct 14, 2007
7
US
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!
 
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
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top