extracting two digit year from date in query

[tomslacks]

I am attempting to extract the two year (03 from 5/6/2003) from a date column and combine the results with another field and I dont know if it can be done. Anyone know how it is done?

T

 

[KenReay]

Hi

Make a 'calculated column' so

CalcColumn: Right(Format(Year(MyDate),"0000&quot,2) & MyOtherCol

To explain:

Year() returns the Year number from a given date (as a number)
Format() returns a string in accordance with the supplied 'mask'
Right() extracts the rightmost 'n' characters from a string

You need to use your own column names of course

Does that help?

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[cottontop]

I would have thought right(year([date])2) would have done the same. I know that using format is a safe bet, but since the default year format of the computer will pull either a 2 or 4 year date, using the above function should do the trick!

 

[gavinjb]

The easiest way would be format([date],"yy&quot

 

[cottontop]

Yep! Duhh!

 

[tomslacks]

awesome thanks to all