View Full Version : How to split the date without "/" in asp?

08-06-2004, 04:48 AM

How to split the date "1/8/2004" in to 01082004?

If posible make it in the single line?
eg: < % Split(strDate, "/") ... ???

PS: i want to add the 0 ,if there are 1 digit of value. -- this is the problem i face on.

08-06-2004, 05:27 AM
I already solve the problem. TQ

08-06-2004, 05:57 AM
Well, glad I could help.

Now there is a little issue of my fee?

$10,000 in small, unmarked bills.
Thank you.

08-07-2004, 05:47 AM
How did you solved it, we might find a similar situation some time... ;)

08-07-2004, 06:45 AM
After I looked at this post, I tried to do it. I tried to use programed in functions, and the best I could do is:

Response.Write Day(Date) & Month(Date) & Year(Date)

This doesn't solve the problem, so I thought making a function would help.

This would work, but is more than one line, so it's what I was hoping:

Function LeadingZero(strVar)
If Len(strVar) = 1 Then
LeadingZero = "0" & strVar
LeadingZero = strVar
End If
End Function

Response.Write LeadingZero(Day(Date)) & LeadingZero(Month(Date)) & Year(Date)

I looked up the format function, but I couldn't find the type of function I was looking for. I want to use something like DateFunction(Date(), "ddmmyyyy").
d - day.
dd - day with leading zero if applicable.
m - month.
mm - month with leading zero if applicable.
yyyy - year.
yy - last two digits of the year.

Also with time.
s - seconds.
ss - seconds with leading zero if applicable.
n - minute
nn - minute with leading zero if applicable.
h - hour
hh - hour with leading zero if applicable.
hhh - hour in military time

And of course any added characters would not be effected, so adding a slash would still be there.

But I can't find a function like this already built into asp.

I know there is function in vb that already has keys and already adds a leading zero:

MsgBox Format(Date, "ddmmyyyy")

I want to find/make the Format function in vb and add it to my webserver, or my included function.asp page.

:eek: :eek: :eek: :eek: :eek: :eek: :eek: :eek: :eek: :eek:

I found this link, which gives me a dll I can register onto my server so it will be allow me to use the format function from vb in ASP.

I also found this link, which shows you the keys for the format function. Something I was looking for already built into ASP.

08-10-2004, 03:52 AM

Actually my solution is what Morgoth mentioned!!! :o)

08-10-2004, 05:14 AM
And for a possible non-DLL-required way to go:

To make a variable be in the format of mm/dd/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)
strMonth = CStr(intMonth)
End If

If intDay < 10 Then
strDay = "0" & CStr(intDay)
strDay = CStr(intDay)
End If

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

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