I would like my date fields to appear like MM/DD/YYYY

[Jeffery B Paarsa]

Hello,

I am getting the system date and printing it into a column by adding one to
the current day and I do this for a whole month... Well I prefer my print out
of my dates comes all the time in 10 characters of MM/DD/YYYY for all the
dates. Currently my date is being printed either 8-9-10 digits if my months
are January thru September or days are 1-9... like this..... 1/1/2008 I
prefer to have it like 01/01/2008... any idea?

 

[Jay Freedman]

Hello,

I am getting the system date and printing it into a column by adding one to
the current day and I do this for a whole month... Well I prefer my print out
of my dates comes all the time in 10 characters of MM/DD/YYYY for all the
dates. Currently my date is being printed either 8-9-10 digits if my months
are January thru September or days are 1-9... like this..... 1/1/2008 I
prefer to have it like 01/01/2008... any idea?

Use the expression Format(Now, "MM/dd/yyyy").