Aug 10, 2003 #1 D2C Programmer Joined Aug 27, 2001 Messages 86 Location BE Hello, does somebody know how I can change my date format from mm/dd/yyyy to dd/mm/yyyy? It's kindy urgent... tnx a lot! d2c
Hello, does somebody know how I can change my date format from mm/dd/yyyy to dd/mm/yyyy? It's kindy urgent... tnx a lot! d2c
Aug 10, 2003 #2 ralphtrent Programmer Joined Jun 2, 2003 Messages 958 Location US try response.write (datepart("d",date) & "/" & datepart("m",date) & "/" & datepart("YYYY",date)) Let me know if this is what you are looking for Upvote 0 Downvote
try response.write (datepart("d",date) & "/" & datepart("m",date) & "/" & datepart("YYYY",date)) Let me know if this is what you are looking for
Aug 10, 2003 #3 Veep Programmer Joined Jan 10, 2002 Messages 1,368 Location US String manipulation. This is courtesy of Bullschmidt from another thread. Not exactly what you're looking for but your answer is somewhere in there: To make a variable be in the format of yyyymmdd, perhaps try something like the following which you might even make into a function: varFld = CDate(MyVariable) intMonth = Month(varFld) intDay = Day(varFld) intYr = Year(varFld) If intMonth < 10 Then strMonth = "0" & CStr(intMonth) Else strMonth = CStr(intMonth) End If If intDay < 10 Then strDay = "0" & CStr(intDay) Else strDay = CStr(intDay) End If varFld = CStr(intYr & strMonth & strDay) Best regards, J. Paul Schmidt, Freelance ASP Web Developer http://www.Bullschmidt.comASP Design Tips, ASP Web Database Demo, Free ASP Bar Chart Tool... Upvote 0 Downvote
String manipulation. This is courtesy of Bullschmidt from another thread. Not exactly what you're looking for but your answer is somewhere in there: To make a variable be in the format of yyyymmdd, perhaps try something like the following which you might even make into a function: varFld = CDate(MyVariable) intMonth = Month(varFld) intDay = Day(varFld) intYr = Year(varFld) If intMonth < 10 Then strMonth = "0" & CStr(intMonth) Else strMonth = CStr(intMonth) End If If intDay < 10 Then strDay = "0" & CStr(intDay) Else strDay = CStr(intDay) End If varFld = CStr(intYr & strMonth & strDay) Best regards, J. Paul Schmidt, Freelance ASP Web Developer http://www.Bullschmidt.comASP Design Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...
Aug 10, 2003 #4 clarkin Programmer Joined Dec 4, 2002 Messages 707 Location IE check onpnt's FAQ on this (see the FAQ button at top of this page..): FAQ333-3194 also some very good stuff here: http://www.aspfaq.com/dates.asp we need an acronym like RTFF Posting code? Wrap it with code tags: [ignore] Code: [/ignore][code]CodeHere [ignore][/code][/ignore]. Upvote 0 Downvote
check onpnt's FAQ on this (see the FAQ button at top of this page..): FAQ333-3194 also some very good stuff here: http://www.aspfaq.com/dates.asp we need an acronym like RTFF Posting code? Wrap it with code tags: [ignore] Code: [/ignore][code]CodeHere [ignore][/code][/ignore].