Date Function

[Keith]

I want to insert the current date into a form field as a default text.

However, when I use <%=Date()%> it insets the date in the format 6/9/2004.

How can I get it to insert the date in UK format (dd/mm/yyyy) using leading
0's for single numbers, so I end up with 09/06/2004?

Thanks

 

[Hans]

Maybe you can get some ideas here
http://www.aspfaq.com/show.asp?id=2313

/Hans

 

[Aaron [SQL Server MVP]]

Also see http://www.aspfaq.com/2260

 

[Bullschmidt]

To make a variable be in the format of dd/mm/yyyy (and the final line of
code can be modifed for other date formats), 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

strYr = Right(CStr(intYr), 4) ' And change the 4 to 2 for 2 year dates.

varFld = CStr(strDay & "/" & strMonth & "/" & strYr)

Best regards,
J. Paul Schmidt, Freelance ASP Web Consultant
http://www.Bullschmidt.com
ASP Design Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...


*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!