[RBASE-L] - Re: FORMAT Question

[A. Razzak Memon]

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.