How do I get a 2 digit date?

T

Tony Williams

I have a control on a form which is a Date/Time control called "txtcd1retd",
its fomat is dd/mm/yy There is another control called "txtYear" with it
control source =Year([txtcd1retd]). If "txtcd1retd" is 01/02/08 I want
txtYear to be 08 but I get 2008. How can I just get 08?
Thanks
Tony
 
T

Tony Williams

Thanks Allen, worked fine
Tony
Allen Browne said:
Try:
=Format([txtcd1retd], "yy")

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Tony Williams said:
I have a control on a form which is a Date/Time control called
"txtcd1retd", its fomat is dd/mm/yy There is another control called
"txtYear" with it control source =Year([txtcd1retd]). If "txtcd1retd" is
01/02/08 I want txtYear to be 08 but I get 2008. How can I just get 08?
Thanks
Tony
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top