<option value="2004-12"> January 2004 </option>
<option value="2003-01"> December 2003 </option>
<option value="2003-01"> November 2003 </option>
<option value="2003-01"> October 2003 </option>
<option value="2003-01"> September 2003 </option>
<option value="2003-01"> August 2003 </option>
<option value="2003-01"> July 2003 </option>
NumberFormat worked. <option
value="#dateYear#-#NumberFormat(dateMonth,'00')#"> gave me the correct
output in the dropdown list.
Thanks everyone for the help!
-----Original Message-----
From: Jim McAtee [mailto:[EMAIL PROTECTED]
Sent: Friday, February 27, 2004 5:16 PM
To: CF-Talk
Subject: Re: Trying to group dates in dropdown list (ALMOST THERE)
In the output you can format the month to two digits: Right("00"
& dateMonth,
2). This can also be done with NumberFormat(), or, if you had
the date
itself you could use DateFormat(thedate, "mm").
----- Original Message -----
From: "Ron Eis" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, February 27, 2004 4:04 PM
Subject: RE: Trying to group dates in dropdown list (ALMOST
THERE)
> Thanks for all the suggestions. I'm almost there but just
have one
> issue left to fix.
>
> How can I get the MONTH(dataDateReported) to return a two
character
> integer? i.e., 01-January, 02-February, 03-March, etc.
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
