[SOLVED] Date in the PAST

Hi Fellow Focus users! Happy Friday.

In the new 8202M Page layout, when a calendar is setup, how can I set the default date to be a date in the past? See image

I use

 WHERE [tablename] GE &STARTDATE.(|FORMAT=YYMD).From Date:.QUOTEDSTRING;

to tell the page I need a calendar. I just don't know how to say I would like the FROM DATE to initially show a date in the past. It always shows today's date.

Any help appreciated. Thank you!

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

WebFOCUS App Studio 8202M
Windows, All Outputs

Posts: 34 | Registered: May 22, 2014

CoolGuy

Virtuoso

posted

Hide Post

Try adding a

-DEFAULTH &STARTDATE = '20180410';

to the top of you fex file with that WHERE statement in place.

8.2.02M (production), 8.2.02M (test), Windows 10, all outputs.

Posts: 1113 | Location: USA | Registered: January 27, 2015

Ignored post by CoolGuy posted

Show Post

ratios

Silver Member

posted

Hide Post

Thanks CoolGuy but that doesn't work. Once you put the "H" it removes the calendar altogether so that at runtime the calendar is not visible.

WebFOCUS App Studio 8202M
Windows, All Outputs

Posts: 34 | Registered: May 22, 2014

Ignored post by ratios posted

Show Post

CoolGuy

Virtuoso

posted

Hide Post

What do you get without the H (-DEFAULT)? Also, what happens with a -SET?

8.2.02M (production), 8.2.02M (test), Windows 10, all outputs.

Posts: 1113 | Location: USA | Registered: January 27, 2015

Ignored post by CoolGuy posted

Show Post

Hallway

Master

posted

Hide Post

It should work with a -DEFAULT, however the default date value needs to be an alpha date

  
-DEFAULT &BEG_DATE = 'April 01 2018';
-DEFAULT &END_DATE = 'April 07 2018';

-TYPE &BEG_DATE.(|FORMAT=YYMD).From Date.
-TYPE &END_DATE.(|FORMAT=YYMD).To Date.

A fex with just the code above and I get this: