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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Dateformat..?
- Thread starter kenjoswe
- Start date
I haven't found a MonthName() type of function in asp. so this is what I do:
'This array hold the names of each month
namesArray = Array("Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec"
monthIndex = rs.Fields("Month" + 1
titleMonth = namesArray(monthIndex)
"<option value=2002-" & titleMonth & ">"
Perhaps the array setup could be in a subroutine, a function , or an include file, depending on how often you use.
---
Another idea would be to convert the month to words in the database. If your database has a 'MonthName()' sort of function, then have it return the month name in the record set, so you don't have to worry about it in ASP.
----------------------------
hope this gives you some ideas,
bp
'This array hold the names of each month
namesArray = Array("Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec"
monthIndex = rs.Fields("Month"
+ 1titleMonth = namesArray(monthIndex)
"<option value=2002-" & titleMonth & ">"
Perhaps the array setup could be in a subroutine, a function , or an include file, depending on how often you use.
---
Another idea would be to convert the month to words in the database. If your database has a 'MonthName()' sort of function, then have it return the month name in the record set, so you don't have to worry about it in ASP.
----------------------------
hope this gives you some ideas,
bp
- Status