I believe there is one small difference between a text string and an internal date format: you can't suppress the leading zero of the "day" part with an internal format. One client of mine has a need for bilingual (French & English) reporting and form letters. Since I had to use a text string to compose the French dates (and times) anyway, I just did the same for English using (CTXT(IDAY(Date))) to suppress the leading zero.
Regards, Stephen Markson ForenSys The Forensic Systems Group www.ForenSys.ca <http://www.forensys.ca/> 416 512 6950 _____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Claudine Robbins Sent: August 5, 2008 1:16 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: FORMAT for Dates Thanks Buddy. I knew about the "easy" one in reports but I was building a text string and needed the other way. Now, I wish I could italicize and bold the text and I'd be all set. _____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Walker, Buddy Sent: Tuesday, August 05, 2008 12:10 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: FORMAT for Dates Claudine Yes in reports, "Display Format" and in forms as long as you add the date column you can select Tables > Display Format then select the appropriate date field. Buddy _____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Claudine Robbins Sent: Tuesday, August 05, 2008 12:44 PM To: RBASE-L Mailing List Subject: [RBASE-L] - FORMAT for Dates I can get what I need with: ((TDWK(.vdeldate))+','&(TMON(.vdeldate))&(CTXT((IDAY(.vdeldate))))+','&(CTXT ((IYR4(.vdeldate))))) But. Is there a (FORMAT (value,'picture-format')) for date values? TIA, Claudine No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.138 / Virus Database: 270.5.12/1592 - Release Date: 8/5/2008 6:03 AM
