Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] M-D date format
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] M-D date format
 Login/Join
 
Gold member
posted
Need a quick way to format a date in M-D.

Like this: Dec-05

Or, how can I select this format in a chart?

thanks

BobV

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


WF (App Studio) 8.2.01m / Windows
Mainframe FOCUS 8
 
Posts: 92 | Registered: February 20, 2008Reply With QuoteReport This Post
Expert
posted Hide Post
Whats the field format ?


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.05OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

 
Posts: 6047 | Location: Land of the Darug people, Terra Australis Incognita | Registered: October 31, 2006Reply With QuoteReport This Post
Expert
posted Hide Post
Is thisw a DB Field? Or, a Amper Variable (Dialogur Manager)?
 
Posts: 2956 | Location: Middle Tennessee [8204M Gen48 in Test&Prod] | Registered: February 23, 2005Reply With QuoteReport This Post
Gold member
posted Hide Post
Have a look at
DATETRAN


WF 8.2.04
Windows/Unix
All Formats
In Focus since 2006
 
Posts: 74 | Location: UK | Registered: September 17, 2018Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Try this......

WMY/MtY = DATEXXXX;

where DATEXXXX is a smart date.


_______________________
*** WebFOCUS 8.1.05M ***
 
Posts: 190 | Location: London, UK | Registered: December 06, 2005Reply With QuoteReport This Post
Guru
posted Hide Post
  
TABLE FILE IBISAMP/EMPLOYEE
PRINT 
    COMPUTE HIRE_MDYY/MDYY = DATECVT(HIRE_DATE, 'I6YMD', 'MDYY') ;   
    COMPUTE HIRE_M-D/A6 = DATETRAN(HIRE_MDYY, '(MD)', '(t-)', 'EN', 6, 'A6');
BY LAST_NAME 
BY FIRST_NAME
BY HIRE_DATE
WHERE DEPARTMENT EQ 'PRODUCTION';
ON TABLE SET PAGE-NUM OFF
END


Hallway
WF(Prod):8202M
WF(Test):8202M
OS/Platform:Win 10
Outputs:All
 
Posts: 309 | Location: Salt Lake City, UT, USA | Registered: November 18, 2015Reply With QuoteReport This Post
Gold member
posted Hide Post
Solved
Thanks all. This DATETRAN worked:

PMT_DATE_MD/A40=DATETRAN (INIT_PMT_DT, '(MD)', '(-t)', 'EN', 40, 'A40');
Results:
Jan-03, Jan-04, Jan-05 etc

BobV


WF (App Studio) 8.2.01m / Windows
Mainframe FOCUS 8
 
Posts: 92 | Registered: February 20, 2008Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] M-D date format

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.