Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [RESOLVED]More data formatting

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[RESOLVED]More data formatting
 Login/Join
 
Ted Michalski
Platinum Member
posted
I'm sure this has come up before, but my forum search skills are not exacly expert.

I need to get the first day of the current month and display it as 1-Oct-12 on a report. how can this be done?

This message has been edited. Last edited by: Ted Michalski,


7.7.02
Windows
EXCEL, PDF, CSV, TEXT
 
Posts: 106 | Registered: June 25, 2009Report This Post
Dgraff
Gold member
posted Hide Post
lOOK AT THE FUNCTION BOM


Duane

WebFOCUS 8.0.7
DS 8.0.7 AS 8.0.7
Windows
Output: Excel, HTML, PDF, AHTML,Mobile
In Focus 1982
 
Posts: 83 | Location: Princeton NJ | Registered: October 26, 2007Report This Post
Waz
Expert
posted Hide Post
I think you mean the function DATEMOV.


Ted,
RTFM.... Read the Functions Manual.

Its all there. The PDF version can be searched for words like beginning or month.


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!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
David Briars
Master
posted Hide Post
Thanks Duane. I hadn't had a chance to check out the DATEMOV function/BOM move-point before.

It looks like this example might assist the OP: 

APP PREPENDPATH IBISAMP
DEFINE FILE TRAINING
 NEW_START1/YMD = DATEMOV(COURSESTART, 'BOM');
 NEW_START2/A9  = DATETRAN(NEW_START1, '(DMY)', '(dt-)', 'EN', 9, 'A9');
END
-*	
TABLE FILE TRAINING
PRINT COURSESTART
      NEW_START1
      NEW_START2
ON TABLE SET PAGE NOPAGE
ON TABLE SET ONLINE-FMT STANDARD
END  

  COURSESTART  NEW_START1  NEW_START2                                           
  -----------  ----------  ----------                                           
  91/02/11     91/02/01    1-Feb-91  
  91/06/05     91/06/01    1-Jun-91  
  91/06/01     91/06/01    1-Jun-91  
  90/11/05     90/11/01    1-Nov-90  
  90/09/28     90/09/01    1-Sep-90  
  89/07/10     89/07/01    1-Jul-89  
  89/05/08     89/05/01    1-May-89  
  91/01/17     91/01/01    1-Jan-91  
  90/04/16     90/04/01    1-Apr-90  
  90/03/26     90/03/01    1-Mar-90  
  91/05/06     91/05/01    1-May-91




Pilot: WebFOCUS 8.2.06 Test: WebFOCUS 8.1.05M Prod: WebFOCUS 8.1.05M Server: Windows Server 2016/Tomcat Standalone Workstation: Windows 10/IE11+Edge Database: Oracle 12c, Netezza, & MS SQL Server 2019 Output: AHTML/XLSX/HTML/PDF/JSCHART Tools: WFDS, Repository Content, BI Portal Designer & ReportCaster
 
Posts: 822 | Registered: April 23, 2003Report This Post
Ted Michalski
Platinum Member
posted Hide Post
Thanks, Waz. Can you point me to the Functions Manual? I imagine it could be quite helpful.


7.7.02
Windows
EXCEL, PDF, CSV, TEXT
 
Posts: 106 | Registered: June 25, 2009Report This Post
Ted Michalski
Platinum Member
posted Hide Post
Thanks David. This works.


7.7.02
Windows
EXCEL, PDF, CSV, TEXT
 
Posts: 106 | Registered: June 25, 2009Report This Post
Waz
Expert
posted Hide Post
The link is at the top of the page, Tech Doc Search

you can download the PDF, or use the HTML online.

I would suggest downloading a set of the manuals for your version its can be very handy.


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!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Francis Mariani
Expert
posted Hide Post
DevStudio > Help > Contents is quite a comprehensive collection of documentation.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [RESOLVED]More data formatting

Copyright © 1996-2020 Information Builders