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