Formatting 'date' parameters to report

  • Thread starter Thread starter SimpleTechie
  • Start date Start date
S

SimpleTechie

I have an Access 02 Report which has 2 parameters: Begin
date and End date. This entry I display on the top of my
form. I want to format this date entered by the user into
dd mmm yy and then write it to the report. As of now it
prints whatever form the user inputs the date in.

Thank you.
 
Use an unbound field and put something like...


=Format([Begin Date],"dd mmm yy")


Rick B



I have an Access 02 Report which has 2 parameters: Begin
date and End date. This entry I display on the top of my
form. I want to format this date entered by the user into
dd mmm yy and then write it to the report. As of now it
prints whatever form the user inputs the date in.

Thank you.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Report Input Parameters 2
print a date range from parameter query on a report header? 2
format function in report control won't work 2
Date format 3
Graph in Report 9
date filter for reports 2
Can you display parameters on reports? 4
Displaying date parameter on a multiple page report 3

Back
Top