Focal Point
Q:How to find out the last date of the month?

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

May 25, 2008, 08:43 PM
Yuuta
Q:How to find out the last date of the month?
Hi,
Like the subject said, is there any way to get the last date of the current month? So for instance current month is May 2008 the last date would be 31 and February 2008 would be 29, thanks~


7.1.3 on XP into HTML, Excel, PDF
May 25, 2008, 11:57 PM
Francis Mariani
Use the DATEMOV function.

Dialogue Manager:

-SET &DT_EOM = 
- DATECVT(( DATEMOV((DATECVT(&YYMD,'I8YYMD','YYMD')),'EOM')),
- 'YYMD','I8YYMD');

-TYPE &DT_EOM


FOCUS:

TABLE FILE CAR
SUM
SALES
COMPUTE DT_EOM/YYMD=DATEMOV('&YYMD', 'EOM');

BY COUNTRY
END



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
May 26, 2008, 12:10 AM
Yuuta
Thank you~


7.1.3 on XP into HTML, Excel, PDF
May 26, 2008, 02:40 AM
FrankDutch
Yuuta

BTW this is available in the manual.
If you would take a look you will find more functions like this one.
To move to begin or end of Week, Quarter, Year
to move to next Business day and many more.
Sometimes manuals are worth to be used....




Frank
prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

May 27, 2008, 04:15 AM
Yuuta
I know, I know... but my company lost the manual years ago(I just got onboard less than 3 months ago) and I don't know where to look for a replacement.


7.1.3 on XP into HTML, Excel, PDF
May 27, 2008, 04:49 AM
Tony A
Yuuta,

There is a very good link at the top right of each forum page entitled "Search the Technical Documentation Library" which opens in a new window. From here you can search for past postings on the Forum or a direct search on the IB Tech DOcs or a combination of both sources.

Alternatively, there used to be a CD with all the documentation for a platform and release available. I always have one close to hand as I then don't require internet access to check the manual.

T


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 
May 27, 2008, 09:06 AM
GinnyJakes
Yuuta,

You will need the "Using Functions" manual for this topic. Do what Tony said and download that one and the language manual at minimum.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
May 28, 2008, 08:59 AM
jgelona
If you are using dev studio, it part of the online help. Just:
Click on Help/Contents;
Click the + next to Developer Studio Online Help;
Click the + next to WebFOCUS 7 Languange Documentation;
Click the + next to Using Functions V7.13.


In FOCUS since 1985. Prod WF 8.0.08 (z90/Suse Linux) DB (Oracle 11g), Self Serv, Report Caster, WebServer Intel/Linux.
May 28, 2008, 09:49 AM
PBrightwell
I would recommend Creating Reports with WebFocus Language, WebFocus Graphics, Describing Data and Using Functions at minimum. If you are doing any administrative work get the administrators guide as well. PDF downloads are free, printed copies you have to pay for.


Pat
WF 7.6.8, AIX, AS400, NT
AS400 FOCUS, AIX FOCUS,
Oracle, DB2, JDE, Lotus Notes
May 28, 2008, 05:55 PM
Waz
As a matter for course I saved copies of all the PDF's and have links to the online manuals available, you never know when you'll need them.

But the most used manual is Using Functions


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!