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     [CLOSED] how DATECVT work?
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] how DATECVT work?
 Login/Join
 
Platinum Member
posted
Hi,

I have following sample code in .fex file:

-SET &YYMD = '20180314';
-SET &MY_YYQ = DATECVT(&YYMD,'I8YYMD','YYMD') ;
-TYPE --------------------------
-TYPE YYMD ----- &YYMD
-TYPE MY_YYQ --- &MY_YYQ
-TYPE --------------------------
RUN
EXIT

and my result:
--------------------------
YYMD ----- 20180314
MY_YYQ --- 42807
--------------------------

can someone explain where/how does '42807' come from?

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


WebFOCUS v8.2.06 , Windows
 
Posts: 126 | Registered: August 29, 2019Reply With QuoteReport This Post
Expert
posted Hide Post
Format YYMD is a "Smart Date" and it effectively the number of days since 1970, if memory serves


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: 6309 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Reply With QuoteReport This Post
Member
posted Hide Post
the value returned for format YYMD is the number of days since the base date - 12/31/1900 I think. the 1970 base is for dates in Unix


WF 8201M/8206, Linux & Windows
 
Posts: 3 | Location: Home-based Kansas City area | Registered: April 16, 2020Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Here's a post with an example of how you might use DATECVT:
how DATECVT work?


WF 8.2.06
Win10 / IE11
AHTML EXL2K PDF
 
Posts: 190 | Registered: October 19, 2010Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] how DATECVT work?

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