Change Date Format

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Charles Deng (anonymous_at_discussions.microsoft.com)
Date: 09/10/04 

Date: Fri, 10 Sep 2004 06:46:07 -0700

Good morning, everybody!

Now I have a question: Can I change date format on my
report?

On design page, I wrote
=Now()

This coding gives Day and Date, such as Friday, September
10, 2004

Is there any way I change the code to only show Date, like:

September 10, 2004

Any advice will be highly appreciated.

Charles

Relevant Pages

  • Re: Excel 2007 auto format pivot table
    ... on the Design Tab you can select from ... Pivot Style Options ... heavy styles don't actually format the report at all. ...
    (microsoft.public.excel)
  • RE: Format report, fixed height for entries that must shrink?
    ... customers when they donate items to our organization. ... for several weeks to find a way to format this report so that each entry is ... format. ... single-column list of items in the design view cannot fit within that height. ...
    (microsoft.public.access.gettingstarted)
  • RE: How do I send a copy of a form to someone else
    ... Design a report that looks sort of like your form. ... format to a college in another office. ... paper work. ...
    (microsoft.public.access.gettingstarted)
  • Re: Crosstab or Pivot Frustration
    ... I have one table with the following design: ... I want to be able to report the data in the following format: ... Your table structure needs normalization. ...
    (comp.databases.ms-access)
  • Counting Largest repeating value in a field
    ... I have a field in a table that uses a defined 2-place number format ... the coding should return 53 and 2500. ... FYI - I intend to use ... this in a report. ...
    (microsoft.public.access.forms)