Hi Stephen,
It doesn't suppress the leading zero in 8.0 either. In my case, it doesn't matter. If it did I would just do it the long way I described in my first message. Claudine ________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Stephen Markson Sent: Wednesday, August 06, 2008 11:43 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: FORMAT for Dates Hi Claudine, I was just trying to point out that, except in reports, you can't suppress the leading zero on the day part of the date with FORMAT. At least not in 7.5. Does it work in 7.6/8? i.e. SET V x= (format(.#DATE,'www+ mmm+ dd, yyyy')) returns "Wednesday August 06, 2008". If you want "...August 6..." instead, (format(.#DATE,'www+ mmm+ d, yyyy')) returns "Wednesday August d, 2008". 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 2:29 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: FORMAT for Dates Thanks Stephen, that's what I was doing with my long and convoluted string in my original message which works just fine but the FORMAT is smaller and much more elegant. Claudine ________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Stephen Markson Sent: Tuesday, August 05, 2008 1:20 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: FORMAT for Dates 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 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
