Date format conversions

[MarkusJohn]

I need an expanded date format for my report. --> September 2006

In my table dates are stored in tt.mm.yy format.
I want to display in the report groups of months.

How can I convert all same months and year dates into the format mm.yy?

I alreade wrote month ([date1]) in the query but this results only the
month number.

Thanks for any help!

 

[Rick Brandt]

I need an expanded date format for my report. --> September 2006

In my table dates are stored in tt.mm.yy format.
I want to display in the report groups of months.

How can I convert all same months and year dates into the format mm.yy?

I alreade wrote month ([date1]) in the query but this results only the
month number.

Thanks for any help!

Dates are always *stored* exactly the same. Formatting is strictly a display
issue.

On your report's TextBox use a format property of...

mmmm yyyy

 

[John Vinson]

I need an expanded date format for my report. --> September 2006

In my table dates are stored in tt.mm.yy format.

Not unless you have them stored in a Text field. A Date/Time field is
actually stored as a number (a count of days and fractions of a day
from midnight, December 30, 1899); the format is JUST for display
purposes.

I want to display in the report groups of months.

You can set the Format property of a report Textbox to mmmm yyyy. If
you wish to *group by* the month, you'll need to base the Report on a
Query with a calculated field converting the date into a text string:

ShowMonth: Format([datefield], "yyyymm")

Use this field for your Sorting and Grouping property of the Report
(you needn't show it on the report); it will sort chronologically.

John W. Vinson[MVP]