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,

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

THANKS

How can I transform DMYY to MDYYtr??

Jenni

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

@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

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