Date Format in Report

[Marie]

Using Access 2000. I have a report--letters to customers--
which is based on a query which is based on several
tables. In the table, I have the date format as mm/dd/yy
(so that it doesn't take up much space in a columnar
report); however, in the letter, I want the date to be in
the format of September 30, 2003. In the properties of the
fldActionDate field, I put mmmmm d", "yyyy; however the
report result puts the date in the format 09/30/2003. What
do I have to do to get the report to display the date as
September 30, 2003.

Thanks for your help.

Marie

 

[Allen Browne]

Try setting the Format property of the text box on your report to:
mmmm d\, yyyy

If Access still does not interpret that correctly, it indicates that it does
not understand the data type being supplied to the text box. If this is a
calculated field from a query or a text field in a table, try wrapping it in
CVDate().

 

[Marie]

My field name in the table (and query) is fldActionDate.
What do you mean by "wrapping it in CVDate()"? I have
tried everything. Would you please give me an example?

Thanks!

Marie

 

[Allen Browne]

If you open the table in design view, what kind of field is fldActionDate?
Does it show as "Date/Time"? If so, Access should be able to interpret it
correctly.

Sometimes people have problems with a calculated date in a query. For
example, if the due date is 14 days after the invoice date, you may have a
Field entry in your query that looks like this:
DueDate: DateAdd("d", 14, [InvoiceDate])
In that case, Access can misunderstand the data type. This is where CVDate()
is useful, by changing the calculated field to read:
DueDate: CVDate(DateAdd("d", 14, [InvoiceDate]))

 

[Marie]

I must have looked at the wrong field when I checked it.
In the table it was as text. I changed it, and it works.
Thanks for your help.

Marie

-----Original Message-----
If you open the table in design view, what kind of field is fldActionDate?
Does it show as "Date/Time"? If so, Access should be able to interpret it
correctly.

Sometimes people have problems with a calculated date in a query. For
example, if the due date is 14 days after the invoice date, you may have a
Field entry in your query that looks like this:
DueDate: DateAdd("d", 14, [InvoiceDate])
In that case, Access can misunderstand the data type. This is where CVDate()
is useful, by changing the calculated field to read:
DueDate: CVDate(DateAdd("d", 14, [InvoiceDate]))

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

My field name in the table (and query) is fldActionDate.
What do you mean by "wrapping it in CVDate()"? I have
tried everything. Would you please give me an example?

Thanks!

Marie table,
try wrapping it in be
in of
the

.