Format Date Question

[luis.a.roman]

Need to have an access formua to retrieve the system date and format
the date as 1/12/2007. I use the expression below but it does not
worked.

Expr1: FormatDateTime(Date(),"yymmdd")

Can someone help me develop the correct formula?

Thank you - Luis

 

[Rick Brandt]

Need to have an access formua to retrieve the system date and format
the date as 1/12/2007. I use the expression below but it does not
worked.

Expr1: FormatDateTime(Date(),"yymmdd")

Can someone help me develop the correct formula?

Why would you expect a format string of yymmdd to produce an output like
1/12/2007?

Expr1: FormatDateTime(Date(),"m\/dd\/yyyy")