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] How the heck to I convert Quarters to a string?
Go
New
Search
Notify
Tools
Reply
  
[Solved] How the heck to I convert Quarters to a string?
 Login/Join
 
Master
posted
I don't know why this is hard, but how do I concatenate a quarter value such as Q1 2010 into a string? Is it with EDIT? DATECVT? I can't find an output format that actually produces a simple representation of quarters.

This gives me the first day of the quarter -- DATECVT(ENCOUNTER_DATE_START, 'MDYY', 'A8MDYY') and I need that too. Is there a format I can put in that will just give me the text representation of a quarter date?

J.

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



 
Posts: 924 | Location: At the Mast | Registered: May 17, 2007Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Is this what you are looking for?

DEFINE FILE CAR
TODAY/MDYY = &MDYY;
QUARTER/QYY = TODAY;
END
TABLE FILE CAR
PRINT CAR
TODAY
QUARTER
END

This message has been edited. Last edited by: Prarie,
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Reply With QuoteReport This Post
Platinum Member
posted Hide Post
This is one way to make a string:

DEFINE FILE CAR
SD_MDYY/MDYY = &MDYY;
QTR/A7 = EDIT(DATECVT(SD_MDYY, 'MDYY', 'Q'),'Q9 ') | EDIT(DATECVT(SD_MDYY, 'MDYY', 'YY'));
END
-*
TABLE FILE CAR
PRINT
CAR
SD_MDYY
QTR
END


WebFocus 8.201M, Windows, App Studio
 
Posts: 221 | Location: Lincoln Nebraska | Registered: August 12, 2008Reply With QuoteReport This Post
Expert
posted Hide Post
Very nice, jfr99.


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, 2005Reply With QuoteReport This Post
Master
posted Hide Post
Yep -- jfr99's got it. Thank you very much!

J.



 
Posts: 924 | Location: At the Mast | Registered: May 17, 2007Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [Solved] How the heck to I convert Quarters to a string?

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