Question Format(Year(Date)) ...to get two digit of the year

[wschian]

Hello, Please Help me

I Want the last two digit of the year, Example "14" for 2014, "15" for 2015

I had try to using Format(Year(Date)) But still cant get,

Format(Year(Date)) show "2014"
Format(Year(Date), "yy") show "05"
Format(Year(Date), "00") show "2014"
Format(Year(Date), "yyyy") show "1905"

TQ

 

[RichP]

try Format(Date,"yy")

 

[wschian]

WORK...TQ... i'm Thinking 1 day