Hi Rob,
It's not clear if date is stored as a date or as a string. If it's stored as a date than you can use YEAR() function. If it's character, than you can use RIGHT() function.
STR(YEAR(mydate),4)
RIGHT(mydate,2)
>question on date field syntax
>
>I need to pull just the year out of a date field...and store
>the year in another field
>
>example: date= "05\26\03"
>
>"03" being the key....pulling just the data to another
>character field say "a1"
>
>the table I'm working with has over 4mil recs...quick and easy!!
>if possible....
--sb--