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!

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

Date problem in a report please help

Status
Not open for further replies.

oldgoldone

Technical User
Apr 24, 2004
13
US
I have this in criteria in my Querry"Date of Service By Quarter: Format$(Service.[DateofService],'q"Quarter "yyyy')
it reports as 3 Quarter 2004 at one time i had it report
Quarter 3 2004 but i cant remember how i did it any help would be great!
 
I Figured it out Date of Service By Quarter: Format$(Service.[Date of Service],'"Quarter "q yyyy')
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top