Focal Point
[SOLVED] Display smart date as 'Monday July 03 2017'

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

July 03, 2017, 12:22 PM
TedB
[SOLVED] Display smart date as 'Monday July 03 2017'
Is there an easy way to display a smart date such as '20170703' as 'Monday July 03 2017' ?

This message has been edited. Last edited by: FP Mod Chuck,


Dev Studio 8.0.09
App Studio 8.2.01
DB2, FOCUS
PDF, HTML, Excel, CSV
In Focus since 1983
July 03, 2017, 01:54 PM
MartinY
The closest that I have is :
-SET &DTE = DATETRAN('20170703', '(YYMD)', '(trwr)', 'EN', 50, 'A50');
-TYPE DTE: &DTE

Which gives ;
DTE: Monday 2017 July 03



WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
July 03, 2017, 01:55 PM
David Briars
DEFINE FILE EMPDATA
-* Reformat smart date.  
 MURRAY/wrMtrDYY = HIREDATE;
END
TABLE FILE EMPDATA
PRINT HIREDATE
      MURRAY
IF RECORDLIMIT EQ 1
ON TABLE SET ONLINE-FMT STANDARD
END  

  HIREDATE  MURRAY                                                              
  --------  ------                                                              
  89/07/12  Wednesday, July 12 1989

July 03, 2017, 02:15 PM
MartinY
Using this way will also give you the result with the year at the end
-SET &DTE = DATETRAN('20170703', '(MDYY)', '(wrtr)', 'EN', 60, 'A60');
-TYPE DTE: &DTE



WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
July 03, 2017, 05:28 PM
Waz
TedB, remember to check the edit option on a field format.

Look at Date Formats


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!