Focal Point
date format

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/5541001351

February 08, 2006, 06:13 AM
Anubha Saini
date format
I want to display date field in "2006-08-02" (yyyy-mm-dd) way how can i do it
February 08, 2006, 06:59 AM
Tony A
Use EDIT -

-SET &MyDate = EDIT(&YYMD,'9999-99-99');

DEFINE FILE CAR
MYDATE/A10 WITH COUNTRY = EDIT('&YYMD','9999-99-99');
END
TABLE FILE CAR
SUM MYDATE
BY COUNTRY
HEADING
"&MyDate"
END


In FOCUS
since 1986		WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
February 08, 2006, 07:10 PM
Piipster
This also works...

TABLE FILE EMPDATA
PRINT HIREDATE
COMPUTE C_DATE_NEW/YY-M-D = HIREDATE;
BY PIN
END


PIN HIREDATE C_DATE_NEW
000000010 89/07/12 1989-07-12
000000020 90/07/18 1990-07-18
000000030 90/04/11 1990-04-11


ttfn, kp


Access to most releases from R52x, on multiple platforms.