Focal Point
[SOLVED] regarding date display format

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

June 21, 2010, 02:14 PM
tsantosh
[SOLVED] regarding date display format
ABLE FILE PERIOD
PRINT OTLT_MRKR_BANK_ID OTLT_ACCT_ID OTLT_NM OTLT_INST_DT OTLT_FRST_POST_DT OTLT_STTS_CD
WHERE DATE_FULL_DT FROM '&FROM_DT' TO '&TO_DATE';
ON TABLE PCHOLD FORMAT HTML
END

here in the above I want to change the code in such a way that i want to have o/p of the date fields as 22-Dec-03.
For the above code i will get as 2007/03/15

These are the date fields
OTLT_INST_DT
OTLT_FRST_POST_DT

Can any one help me please?

This message has been edited. Last edited by: Kerry,


WebFOCUS 7.6
Windows, all output
June 21, 2010, 02:36 PM
rfbowley
In the documentation for your installation, in the book "Dexcribing Data" you will find a section on "Date Display Options". On the presumtion that your data field is a YYMD format, I suggest the DMtYY format.

PRINT 
  OTLT_MRKR_BANK_ID 
  OTLT_ACCT_ID 
  OTLT_NM 
  OTLT_INST_DT/DMtYY
  OTLT_FRST_POST_DT/DMtYY
  OTLT_STTS_CD



Robert F. Bowley Jr.
Owner
TaRa Solutions, LLC

In WebFOCUS since 2001
June 21, 2010, 03:02 PM
tsantosh
thnks


WebFOCUS 7.6
Windows, all output