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] ALPHA TO DATE (I8YYMD)
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] ALPHA TO DATE (I8YYMD)
 Login/Join
 
Platinum Member
posted
Hi,

How can I convert a Alpha value (A10: dd.mm.yyyy) to a Date Value???


It's necesary because I Need to filter my Report with Dashboard Text Prompt.
I want to FIlter the Date with GE or LE.

Just works with I8YYMD.

Thanks!!!

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


WebFOCUS 8.1.05
Windows, All Outputs
 
Posts: 177 | Registered: October 17, 2017Reply With QuoteReport This Post
Silver Member
posted Hide Post
DATECVT(date, 'in_format', output)


WebFOCUS 8.2.02M
Windows
Server/8.2.02M
All Outputs
 
Posts: 43 | Location: Odessa, Florida | Registered: July 26, 2011Reply With QuoteReport This Post
Virtuoso
posted Hide Post
  
DEFINE FILE CAR
DATE_A10/A10 WITH CAR = '22.10.2018';
DATE_A8DMYY/A8DMYY=EDIT(DATE_A10,'99$99$9999');
DATE_I8DMYY/I8DMYY=EDIT(DATE_A8DMYY);
END
TABLE FILE CAR
PRINT DATE_A10 DATE_A8DMYY DATE_I8DMYY
BY COUNTRY
BY CAR
END


WebFOCUS 8206, Unix, Windows
 
Posts: 1658 | Location: New York City | Registered: December 30, 2015Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] ALPHA TO DATE (I8YYMD)

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