long date

  • Thread starter Thread starter siggy
  • Start date Start date
S

siggy

in a query, I prompt for a date range ( mm/dd/yyyy )
-- works great

in a report based on the query, I want to re-display the entered
date in a long-date format..... cannot figure out a way......
( I can only get the mm/dd/yyyy displayed --- or an error )


thanks
siggy
 
Set the Format property of the textbox control that's displaying the date to
Long Date.
 
"failed" doesn't give us much to go by...

So, you've got a query and you've set a parameter along the lines of [Enter
Date (mm/dd/yyyy)], and you're putting =[Enter Date (mm/dd/yyyy)] as the
control source for a textbox on your report.

Two options.

With your query open in Design Mode, select Query | Parameters... from the
menu bar. In the dialog that appears, type the name of your parameter
exactly as entered in the query in the Parameter column, and Date/Time as
the Data type.

Alternatively, in your report, put =CDate([Enter Date (mm/dd/yyyy)]) as the
control source
 
Try this --
In query design view copy your prompt (so that it will be identical) and
paste in a new column to create an output something like this --
My Date Range: CVDate([Enter the date range])

Use this output in your report and set format for the field to your long
date format.
 
=CDate([Enter Date]) --- and setting format to Long Date

** worked - great ----- thanks a 'bunch'





Douglas J. Steele said:
"failed" doesn't give us much to go by...

So, you've got a query and you've set a parameter along the lines of
[Enter Date (mm/dd/yyyy)], and you're putting =[Enter Date (mm/dd/yyyy)]
as the control source for a textbox on your report.

Two options.

With your query open in Design Mode, select Query | Parameters... from the
menu bar. In the dialog that appears, type the name of your parameter
exactly as entered in the query in the Parameter column, and Date/Time as
the Data type.

Alternatively, in your report, put =CDate([Enter Date (mm/dd/yyyy)]) as
the control source

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



siggy said:
tried -- and failed
Click to expand...
Click to expand...
 
Back
Top