Friday, February 24, 2012

format date from 2/25/2006 to 02/25/2006

in footer of my report i show a current date by this

=Format(Today(), "d")

as a result i gave those

3/21/2007

but wont date like this 03/21/2007

How ?

Use this expression:

Format(Today,"MM/dd/yyyy")

Can you please mark my post as answer after that?

No comments:

Post a Comment