Formating Date Range from Query to Report

[Guest]

I am unable to format a date range from a query to a report
The query asks for [Start Date] and [End Date].

The [Start Date] and [End Date] are place on the report header.

Unable to format using the format property ot the text box.

The format should be "mmmm dd, yyyy" ex: January 1, 2005

Help needed thank you

Ileana

 

[fredg]

I am unable to format a date range from a query to a report
The query asks for [Start Date] and [End Date].

The [Start Date] and [End Date] are place on the report header.

Unable to format using the format property ot the text box.

The format should be "mmmm dd, yyyy" ex: January 1, 2005

Help needed thank you

Ileana

As control source of an unbound control in the report header:
="For sales between " & Format([Start Date],"mmmm dd, yyyy") & " and "
& Format([End Date],"mmmm dd, yyyy")

 

[Guest]

Thank You Fred

The format syntax worked prefectly

Ileana

I am unable to format a date range from a query to a report
The query asks for [Start Date] and [End Date].

The [Start Date] and [End Date] are place on the report header.

Unable to format using the format property ot the text box.

The format should be "mmmm dd, yyyy" ex: January 1, 2005

Help needed thank you

Ileana

As control source of an unbound control in the report header:
="For sales between " & Format([Start Date],"mmmm dd, yyyy") & " and "
& Format([End Date],"mmmm dd, yyyy")