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. >> > > >
