Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Displaying Date 1

Status
Not open for further replies.
kermitforney

kermitforney

Technical User
Mar 15, 2005
374
US
Need to include a date in a report that I have created.
In the table it is stored as a short date, ex.: 09/12/06. But I need it to display in the report as, "September, 2006". With just the month and year information.

Any tips?
 
Sort by date Sort by votes
In the report, right click on the Properties for the date field, and then set its Format to mmmm, yyyy

Tom
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

caykamanj1966
  • Locked
  • Question
Search by Date and Some Text
Replies
9
Views
277
dhookom
dhookom
FancyPrairie
  • Locked
  • Question
How to Format a date on a report
Replies
1
Views
355
sxschech
sxschech
misuser2k7
  • Locked
  • Question
Hide date textboxes on report 1
Replies
4
Views
165
misuser2k7
misuser2k7
integritycare
  • Locked
  • Question
Hi, I need to put the date in the
Replies
11
Views
198
dhookom
dhookom
monkeysee
  • Locked
  • Question
Report based on current date. 1
Replies
1
Views
96
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top