-
I have a date value stored in access in this format:
1/8/2000
I need to parse all these dates out in this format:
8/2000
or
82000
basically, I just need the month and year as a string.
how do i do this in VBscript?
if it helps you show me the syntax, im pulling the date with this:
rstNews("dtDate")
which will return the above mentioned 1/8/2000
-
Hi glitch13
Nice and easy on this. just use the following
<%
Dim dtMonth
Dim dtYear
Dim dtDate
dtMonth = Month(rstNews("dtDate"))
dtYear = Year(rstNews("dtDate"))
dtDate = dtMonth & "/" & dtYear
%>
Hope this helps
Ian
-
thanks alot, works fine. I never new there were any other time/date formating functions other than DateTimeFormat()