End date cannot be before start date

[aislinn]

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?

[mr_vodka]

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.

[aislinn]

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.

[mr_vodka]

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

FakeCalendar.zip

[aislinn]

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)?

[mr_vodka]

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.

[Cabinetman]

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

Where'd you get that function?

Edited September 9, 2008 by Guest

[mr_vodka]

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.

[Cabinetman]

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