How do I get a 2 digit date?

  • Thread starter Thread starter Tony Williams
  • Start date Start 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
 
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
Click to expand...
Click to expand...
 
Back
Top