PDA

View Full Version : format date

esthera
08-23-2006, 08:58 AM
how can i format a date to mmddyyyy regardless of what the system setting is?
Spudhead
08-23-2006, 01:02 PM
<%=month(Date) & day(Date) & year(Date)%>
degsy
08-31-2006, 04:50 PM
If you want to accomodate for leading zeros then you can use string functions


<%=Right("0" & month(Date),2) & Right("0" & day(Date),2) & year(Date)%>