Date Format in a Query

[tma12000]

Hi there,
I am trying to create create a query that will automatically generate a service ticket# when certain fields on a form are entered. The date is a Now() function off the original table. For purposes of the ticket# I need to have only the "03" pulled off the end of the date. Here is what the query would look like if I could use the entire date. Any help with the code to pnly reflect the last 2 digit of the year would be greatly appreciated.

Ticket#:[dateelement#1]&[dataelement#2]&[DATE]

How do I get the "DATE" to only show the "03" in 2003?

Thanks,
Tim

 

[PaulBricker]

Ticket#:[dateelement#1]&[dataelement#2]& Year(Date)

 

[tma12000]

Thanks Paul, the output of that gave me the whole year (2003), how would I get to just the "03"

THanks again,
Tim

 

[PaulBricker]

This should do it.

Ticket#:[dateelement#1]&[dataelement#2]& Format(Date,"yy&quot


Paul