Strip out a portion of a string

[jasonsalas]

Hi everyone,

I've got a string value that I'm pulling out of a database, which is rendered by the VBScript FORMATDATETIME function:
FormatDateTime(objRS("Date&quot,1)

The data is, of course, presented like so:
June 12, 2002

But I'd like to display this only as "June 12".

Any ideas? Is there anything in VBScript comparable to JavaScript's Substring method?

Thanks!

 

[codestorm]

how about something like

dim str_tempdate
str_tempdate = objRS("Date&quot
str_tempdate=left(str_tempdate,1, instr(str_tempdate, ",&quot-1) codestorm
Fire bad. Tree pretty. - Buffy
select * from population where talent > 'average'
<insert witticism here>

 

[onpnt]

Dim MyString, LeftString
MyString = &quot;June 12, 2002&quot;
LeftString = Left(MyString, 6) ' LeftString contains &quot;June 12&quot;.
I may not get it the 1st or 2nd time,
but how sweet that 15th time can be.

 

[onpnt]

you beet me codestorm. I may not get it the 1st or 2nd time,
but how sweet that 15th time can be.

 

[jasonsalas]

Thanks guys. I was actually able to hit it right on the mark with the following:

dateArray = Split(FormatDateTime(Date(),1),&quot;,&quot
Response.Write(dateArray(1))

 

[jasonsalas]

...oops...that should have read:

dateArray = Split(FormatDateTime(objRS(&quot;Date&quot,1),&quot;,&quot
Response.Write(dateArray(1))

 

[codestorm]

I would have thought it would have been dateArray(0) codestorm
Fire bad. Tree pretty. - Buffy
select * from population where talent > 'average'
<insert witticism here>

 

[jasonsalas]

I thought that, too...but Response.Write'ing out the zero-based index of the array returns &quot;Wednesday&quot;.

jason