Hi there!

I've been tossing and turning over this one; I'm convinced it has a relatively easy solution but I can't seem to find it.

In my database, I have 2 sets of dates: Start and End, both working with a dropdown calendar on the layout. What I would now like to do is, when the Start date is filled out, set the value of the End dropdown calendar to at least the same date as Start, [color:red]without actually showing that date as a field value!

This to avoid that the user thinks he has already filled out the End date.

Suggestions, anyone?

The drop down calendar defaults to the current date if the field is blank. If the field has a value in it, it will show that date as the default in the calendar.

There is no way (sans a plugin possibly or creating your own popup calendar) to set that calendar default date to a date of your choice.

OK, short and to the point. I like that, even though your message has devastated me... I was soooo convinced that there would be an easy workaround.

Thanks anyway.

Well you can try something like this. Its a trick but perhaps it can work for you.

FakeCalendar.zip

LET (trigger = Hide; ...)

Trying to understand the logic behind the solution. What does "trigger" do? Is it a variable (I don't see the classic "$" variable indicator)? Or a function (can't see it in my functions list)?

You can set a variable for the duration of the calc without referencing it such as a script local variable with $. Check out the help file on Let (). Basically, it is being used as a way to force the calc to recalcuate when the value of the other field Hide changes.

My question is I'm not familiar with 'trigger' as in the calc.

Where'd you get that function?

Edited September 9, 200817 yr by Guest

Its not a function. Its a local calc variable that I am setting using the let statement. I could call it hamburger instead of trigger if I wanted to.

Its not a function. Its a local calc variable that I am setting using the let statement. I could call it hamburger instead of trigger if I wanted to.

Aaaaaaaaaaaaaaaaahhhhhhhhhhhhhhhhh !

Very weak on calc.'s but I just learned something useful after dissecting the hide calc.

Thanks