Formating Date Range from Query to Report

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

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
 
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
Click to expand...


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")
 
Thank You Fred

The format syntax worked prefectly

Ileana

fredg said:
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
Click to expand...


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")
Click to expand...
 
Back
Top