Hi Team,

I tried to create / set a dynamic date value in calendar using prompt. But it is not taking up. Can you help me out? Below is the code


-SET &STARTDATE_YYMD = DATECVT(DATEADD(DATECVT(&YYMD, 'I8YYMD', 'YYMD'), 'M', '-1'), 'YYMD', 'I8YYMD');
-SET &STARTDATE_MONTH = LCWORD(10, CHGDAT('YYMD','MX', &STARTDATE_YYMD, 'A10'), 'A10');
-SET &STARTDATE_DAY = CHGDAT('YYMD','DX', &STARTDATE_YYMD, 'A2');
-SET &STARTDATE_YEAR = CHGDAT('YYMD','YYX', &STARTDATE_YYMD, 'A4');
-SET &STDT = TRUNCATE(&STARTDATE_MONTH) | ' ' | TRUNCATE(&STARTDATE_DAY) | ' ' | TRUNCATE(&STARTDATE_YEAR);

-SET &ENDDATE_YYMD = DATECVT(DATEADD(DATECVT(&YYMD, 'I8YYMD', 'YYMD'), 'D', '0'), 'YYMD', 'I8YYMD');
-SET &ENDDATE_MONTH = LCWORD(10, CHGDAT('YYMD','MX', &ENDDATE_YYMD, 'A10'), 'A10');
-SET &ENDDATE_DAY = CHGDAT('YYMD','DX', &ENDDATE_YYMD, 'A2');
-SET &ENDDATE_YEAR = CHGDAT('YYMD','YYX', &ENDDATE_YYMD, 'A4');
-SET &ENDDT = TRUNCATE(&ENDDATE_MONTH) | ' ' | TRUNCATE(&ENDDATE_DAY) | ' ' | TRUNCATE(&ENDDATE_YEAR);

-TYPE STARTDATE_YYMD &STARTDATE_YYMD
-TYPE STARTDATE_MONTH &STARTDATE_MONTH
-TYPE STARTDATE_DAY &STARTDATE_DAY
-TYPE STARTDATE_YEAR &STARTDATE_YEAR
-TYPE STDT &STDT

-TYPE ENDDATE_YYMD &ENDDATE_YYMD
-TYPE ENDDATE_MONTH &ENDDATE_MONTH
-TYPE ENDDATE_DAY &ENDDATE_DAY
-TYPE ENDDATE_YEAR &ENDDATE_YEAR
-TYPE ENDDT &ENDDT

-*-DEFAULT &STARTDATE='March 18 2018';
-*-DEFAULT &ENDDATE='April 17 2019';
-DEFAULT &STARTDATE = '&STDT.EVAL';
-DEFAULT &ENDDATE = '&ENDDT.EVAL';
PROMPT &STARTDATE.(|FORMAT=MDYY).StartDate:.QUOTEDSTRING;
-PROMPT &ENDDATE.(|FORMAT=MDYY).EndDate:.QUOTEDSTRING;


When you provide as a static value it is working however for dynamic it is not showing the value which calculated.

Below is the reference URL:
https://webfocusinfocenter.inf...d9-9726-FC3291EDC48F

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

subbu_088

I am going to close this thread seeing you have posted it in the other and getting advice.