Formating a Date

  • Thread starter Thread starter Kagsy
  • Start date Start date
K

Kagsy

Dear all,

Thanks to all that responded to my previous Date Dilema
posting. It has helped me but I have a supplementary
question that follows on from one of John Vinson's
comments. Is there a difference between:

Format([datefield], "mm\/dd\/yyyy"), and
Format([datefield], "mm/dd/yyyy")

Do they amount to the same thing? Thanks for your help.

Kagsy
 
Format([datefield], "mm\/dd\/yyyy") formats the date with the slash as date
separator in the output.

Format([datefield], "mm/dd\yyyy") formats the date with date separator in
the output defined in regional settings. This might be the slash but can be
any character. The slash is used as separator in the format specification.
 
Back
Top