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] Pages Datepicker from to
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Pages Datepicker from to
 Login/Join
 
Platinum Member
posted
Hi,

I want a "between" date in my Page.

When I simply use
WHERE DATE GE &DATE_FROM.(|FORMAT=DMYY).DATE FROM:.QUOTEDSTRING;
WHERE DATE LE &DATE_TO.(|FORMAT=DMYY).DATE TO:.QUOTEDSTRING;

i get a date picker. - good
But when I select a date, it appears e.g. 1.Nov.20182018 for my Parameter - Looks bad!!!
Which Format of my Date do I have to use to let the date picker look normal?

Tried with HDMYYS, YYMD, DMYY., DMYY
I prefere DMYY.

Can you create a quick CAR example?

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
Virtuoso
posted Hide Post
The problem is not with the WHERE clause but the auto-prompt calendar that return a specific date format which you need to match with
DEFINE FILE GGSALES
DATEX /MDYYtr = DATE;
END
TABLE FILE GGSALES
SUM DOLLARS
BY REGION
BY DATEX
WHERE DATEX GE &DATE_FROM.(|FORMAT=DMYY).DATE FROM:.QUOTEDSTRING;
WHERE DATEX LE &DATE_TO.(|FORMAT=DMYY).DATE TO:.QUOTEDSTRING;
END
-RUN


WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2282 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Reply With QuoteReport This Post
Platinum Member
posted Hide Post
THANKS

How can I transform DMYY to MDYYtr??


WebFOCUS 8.1.05
Windows, All Outputs
 
Posts: 177 | Registered: October 17, 2017Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Jenni

Any smart date can be transformed into another format simply by using a DEFINE as Martin showed in his example.


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 1749 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
Platinum Member
posted Hide Post
@FP Mod Chuck... I know, but it's just not working for my DMYY Format.

For YYMD it's easy. I wouldn't ask if I would not Need a hint and sorry, but yours is so really not helpful.

So If someone else could maybe help me to solve my Problem

-SET &ECHO=ALL;

DEFINE FILE CAR
THISDATE/A8YYMD = EDIT('&YYMD','99999999');
THIS_DATE/I8YYMD = EDIT(THISDATE);
RIGHT_FORMAT/MDYYTR = THIS_DATE;
END

TABLE FILE CAR
PRINT
COUNTRY NOPRINT
RIGHT_FORMAT
END


WebFOCUS 8.1.05
Windows, All Outputs
 
Posts: 177 | Registered: October 17, 2017Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Solved it by myself.. Can't use this in Infoassist, but it works.


-SET &ECHO=ALL;

-SET &THISDAY =EDIT(&DATUM, '99$$$$$$$$');
-SET &THISMONTH =EDIT(&DATUM, '$$$99$$$$$');
-SET &THISYEAR =EDIT(&DATUM, '$$$$$$9999');
-SET &OTHERFORMAT = EDIT(&THISYEAR) |'.'| EDIT(&THISMONTH) |'.'| EDIT(&THISDAY);


DEFINE FILE baseapp/CAR
DATE/YYMD = '&OTHERFORMAT';
THISDATE/A8YYMD = DATE;
-*EDIT(DATE,'99999999');
THIS_DATE/I8YYMD = EDIT(THISDATE);
RIGHT_FORMAT/MDYYTR = THIS_DATE;
END

TABLE FILE baseapp/CAR
PRINT
COUNTRY NOPRINT
DATE
RIGHT_FORMAT
-*ON TABLE HOLD AS A1 FORMAT BINARY
END

-*?FF A1


WebFOCUS 8.1.05
Windows, All Outputs
 
Posts: 177 | Registered: October 17, 2017Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Pages Datepicker from to

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