Razzak, After confessing that I've been living in the Stone Age, I have one word for you:
WOW! Not only does this method solve my problem, but it also removes the telltale leading zero from single-digit dates. I am often reluctant to broadcast my problems but they are most often met with solutions, thanks to you and others. That's what counts!. I'm having fun! Thanks, Fred ----- Original Message ----- From: "A. Razzak Memon" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[email protected]> Sent: Saturday, June 07, 2008 10:25 PM Subject: [RBASE-L] - Re: SET DATE > At 10:00 PM 6/7/2008, Fred C Kopp wrote: > >>I like my default date format to be MM/DD/YY. >> >>I run a routine from a button within a form that prints a form letter. Prior >>to the command that prints the letter I enter a line SET DATE 'MMM+ DD, YYYY' >> >>The letter prints fine, such as June 07, 2008. >> >>After the letter is printed, I <F8> to the next record. The date >>format remains >>'MMM+ DD, YYYY' even though I have entered SET DATE MM/DD/YY >>everywhere I can >>think of to enter it. This includes all the obvious places: in the >>oonrrol file >>itself, in the AFTER REPORT GENERATED, to the ON CLOSE from the >>form--no matter >>what I do the next record <F8> displays dates as MMM+ DD, YYYY. >> >>My command SET DATE MM/DD/YY is being ignored. I simply want to >>restore my date >>format to my chosen default format. What gives? > > > Fred, > > You should never muck with the database default DATE settings just to PRINT > a report. > > Did you know that you can use the "Display Format..." option for that exact > control to achieve your goal? > > Here's how: > > 01. While in report designer, right-click on the specific control and select > "Display Format..." from the speed menu options. > > 02. Notice the following available options: > > m/d/yy > d/m/yy > mm/dd/yy > dd/mm/yy > mm/dd/yyyy > dd/mm/yyyy > d-mmm-yy > dd-mmm-yy > mmmm d, yyyy > m/d > mmm-yy > mmmm-yy > dddd, mmmm dd, yyyy > > 03. Select the appropriate display format and click on [OK] button. > > 04. You may overwrite to further customize the format, if you wish. > > 05. Click on [Report Preview] tab to preview the actual report. > > 06. Save the report and close report designer. > > That's all there is to it! > > Have fun. > > Very Best R:egards, > > Razzak. > >
