DateTimeFormat?

[glitch13]

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

[Ianpbaker]

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

[glitch13]

thanks alot, works fine. I never new there were any other time/date formating functions other than DateTimeFormat()