Date Format Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Scenario: I have a WORD document that is merged with an ACCESS query. My
date field currently is: (i.e., April 05, 2005). I would like to add the
"day of the week" to the front of the date: (i.e., Tuesday, April 5, 2005).
I'm self-taught in ACCESS. This is not the current day's date, but a
scheduled appointment date and time. Thanks for your help.
 
geo-wv said:
Scenario: I have a WORD document that is merged with an ACCESS query. My
date field currently is: (i.e., April 05, 2005). I would like to add the
"day of the week" to the front of the date: (i.e., Tuesday, April 5, 2005).
I'm self-taught in ACCESS. This is not the current day's date, but a
scheduled appointment date and time. Thanks for your help.
Click to expand...

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Use the Format() function w/ "Long Date" parameter:

Format(Date(), "Long Date") -> Tuesday, April 05, 2005

Put the name of the column in place of the "Date()" parameter.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQlLOJ4echKqOuFEgEQI1bACgz/sOGnn+PYYrhvV2XFSS26RqfSQAoLKp
aHVX+aRxZA3YwMJ9nreYS1vn
=CtiY
-----END PGP SIGNATURE-----
 
Back
Top