Scan function??

[Alex Pavluck]

How can I do this in Access? I can do it in 2 seconds in SQL but I
can't even get it to work in the SQL editor in Access

Date field is like this:
'2004 - 2006'

I just want to pull off the first year. I can do it with this code in
SQL:

Scan(Date, 1) as Start format $4.

Thanks!

Alex

[JvC]

This should do it:

Trim(Left(MyDateString, InStr(MyDateString, "-") - 1))

Alex Pavluck explained on 8/3/2008 :

How can I do this in Access? I can do it in 2 seconds in SQL but I
can't even get it to work in the SQL editor in Access

Date field is like this:
'2004 - 2006'

I just want to pull off the first year. I can do it with this code in
SQL:

Scan(Date, 1) as Start format $4.

Thanks!

Alex

[Alex Pavluck]

On Aug 3, 8:51*pm, JvC <[e-mail]:

This should do it:

Trim(Left(MyDateString, InStr(MyDateString, "-") - 1))

Alex Pavluck explained on 8/3/2008 :

How can I do this in Access? *I can do it in 2 seconds in SQL but I
can't even get it to work in the SQL editor in Access

Date field is like this:
'2004 - 2006'

I just want to pull off the first year. *I can do it with this code in
SQL:

Scan(Date, 1) as Start format $4.

Thanks!

Alex

Thanks so much!

This did it once I fixed a bug in Access
http://support.microsoft.com/kb/275110

Thanks again!
Alex