Jim, Dennis, Razzak, James,
Thank you all for responding. The old way works with MMM for the desired result of "Sep" so I'll continue using that. Claudine _____ From: [email protected] [mailto:[email protected]] On Behalf Of James Bentley Sent: Saturday, September 17, 2011 3:02 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: FORMAT Question Claudine, I agree with Dennis. This appears to be a boo-boo. Additional syntax of 'MMM+' or 'MMMM' as defined for date do not work either. I think all options for DATE should work for the date part of DATETIME. Please consider submitting to RDCC as an error. Jim Bentley American Celiac Society [email protected] tel: 1-504-737-3293 _____ From: Dennis McGrath <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Saturday, September 17, 2011 2:13 PM Subject: [RBASE-L] - Re: FORMAT Question Claudine, Methinks you have found a boo-boo YYYY-MM-DD HH:NN:SS works YYYY-MMM-DD HH:NN:SS does not Dennis McGrath [email protected] [email protected] On Sat, Sep 17, 2011 at 1:56 PM, A. Razzak Memon <[email protected]> wrote: At 02:38 PM 9/17/2011, Claudine Robbins wrote: R>SET VAR vts TEXT = ((FORMAT (.#DATE,'YYYY-MMM-DD')) & (CTXT(.#TIME)) );sho v vts 2011-Sep-17 13:35:32 I wanted to "modernize" my variable but this is the result: R>SET VAR VTS TEXT = (FORMAT (.#NOW,'YYYY-MMM-DD HH:NN:SS'));SHO V VTS 2011-09M-17 13:32:28 Can anyone see what I am doing wrong? Claudine, Here are a few examples that you can use to achieve your goal: -- Examples to use FORMAT function with .#DATE, .#TIME, and .#NOW CLEAR VARIABLES v1,v2,v3,v4,v5 SET VAR v1 TEXT = (FORMAT(.#DATE,'MMDDYYYY')) SET VAR v2 TEXT = (FORMAT(.#TIME,'HHMM')) SET VAR v3 TEXT = (FORMAT(.#NOW,'MMDDYY_HHNN')) SET VAR v4 TEXT = (FORMAT(.#NOW,'YYYY-MM-DD HHNNSS')) SET VAR v5 TEXT = (FORMAT(.#NOW,'YYYY-MM-DD HH:NN:SS')) Hope that helps! Very Best R:egards, Razzak.
