Im looking to have a calendar field default to 14 days ago....

[Guest]

Hi John

I think youre talking about datepicker.jsp. Its been a while since I used that.

Heres something that might help:

jquery ui - How to set a default month for datepicker when unselecting all dates - Stack Overflow

[John Edwards 2]

Im looking to have a calendar field default to 14 days ago. As-is it defaults to today, and I can set it to a particular date like 01/01/2021, but Id like it to default to 14 days ago.

Question Is this possible

[John Edwards 2]

Does IBs screen painter use datepicker.jsp None of the materials in the Helpful Link url on that page looks familiar. It used to be dyncalendar, dont know if it still is.

[Toby Mills]

Hi John

I dont really know since I do so much admin work lately.

Were using datepicker at my current site, so thats what popped in my mind. But - we also have a strong javascript guy that wrote those screens.

The other folks here will undoubtedly have a better answer for you.

What release are you on

A quick look around yielded this - maybe itll be helpful for you

Setting Dynamic Default Values for Filter Controls

https://kb.informationbuilders.com/topic/personalizing-default-values-filter-controls-8207

One of our good front-end myibi members will be able to help.

Toby

[David Beagan]

The link Toby provided is for a control in Designer. Are you working in Designer

[Warren Hinchliffe]

Yes, more info or screen shots would be great.

There are many options in WebFOCUS for Date controls and all are handled differently

[John Edwards 2]

Yes, Im working in Designer. How do I set it to default to 14 days ago when the screen opens please

[David Beagan]

The basic idea is that in Designer, the properties for a control has a Default value entry. You put in a global variable for the default value, for example, &&Date14.

This global variable needs to have its value established before the Designer page runs.

-SET &&Date14 = AYMD(&DATEH8, -14, 'I8YYMD');

 

This could be done in the global server profile (edasprof.prf). Or it could be done in a fex you designate to run on user sign-in:

Administration Console / Application Settings / Other / Paths to be executed on user Sign-on

and enter the path to the fex, IBFS:/WFC/Repository/ .

[John Edwards 2]

Oh wow. I was just about to write JavaScript and load it that way. Youre saying I can put an amper-variable into the default value field . . . wouldnt have guessed that would work.

This unit is called from an MRE stub, so I can just put it there. Thanks for the tip.

[David Beagan]

You are welcome. Just to be clear, it needs to be a global amper variable (two ampersands).

[John Edwards 2]

This didnt work. Is there a trick Im missing I got the literal value &&FOURTEEN_DAYS_AGO in the field instead of it resolving.

[David Beagan]

Your screenshot is from App Studio HTML Canvas, not Designer. Let me see what I can come up with.

[John Edwards 2]

Thanks anyway, but I wrote JavaScript. Its done. I just load straight into the innerHTML.

Generally a roll my own for UI, so I cant keep up with the difference between Canvas and Designer. Last I knew it was Composer. IB likes to change the name of things every year, heres hoping Tibco puts an end to that bad habit.

[David Beagan]

Your .htm file created in HTML Canvas will need to be called from a fex using the -HTMLFORM command. (You will call this fex instead of the .htm file.)

For example if your .htm was named days_ago.htm then the fex would have:

-SET &FOURTEEN_DAYS_AGO = EDIT(DATECVT(DTADD('&DATEMTBDBYY', DAY, -14) , 'MDYY' , 'A8MDYY'), '99/99/9999');

 

-HTMLFORM IBFS:/WFC/Repository/Public/days_ago.htm

 

In the .htm you reference the variable as !IBI.AMP.FOURTEEN_DAYS_AGO;

 

I tested this in 8.2.06:

[John Edwards 2]

Oh man, I should have thought of that. I use !ibi references all over the place, should have twigged on to needing to do that in this setting as well. Ill give that a shot just to prove the concept, but I have the js code in production already.

Thanks for the tutorial. If myibi is anything like Focal Point, Ill be searching for a solution to this same problem five years from now. Ill be sure to thank you again when that happens.

[Douglas Lee 2]

That all sounds good However, can the Default for a Calendar control be set entirely from within Designer 8207 Case in point:

 

An Old File is used as a source which only has data, and date fields, for 2014-2016.

The report Filter is set for the Date Selected from the Calendar.

The report is Sorted by Highest 7 dates.

The Calendar Control needs to have its Default set to Dec 31 2016, not the current date.

** Or, set to the MAX Date in the Source File.