Newbie Questions

Re: Find the first date from several date pickers

Crazy Vinnie — Thu, 30 Apr 2009 14:04:53 GMT

Thanks for the reply, it helped. I actually didn’t need that many rules. It was the possibility of blanks that was giving me a hard time. By giving the date pickers a default value of something impossibly high and setting some conditional formatting to hide that value, I was able to get the results I needed.

Re: Find the first date from several date pickers

Hilary Stoupa — Mon, 20 Apr 2009 00:40:54 GMT

You may be able to do this with rules, but you'll need a lot of them. You'd need to set rules on each of the fields that are bound to the date pickers, with conditions -- for example, if only one date picker field has a value, that should be the one in the text box. If more than one is filled out, your condition will need to compare the current field, with the rule on it, to the other fields that have dates, and then, if it less, populate the text box field with its value. I can't really think of a less complex way to do this without code, I'm sorry.

Find the first date from several date pickers

Crazy Vinnie — Wed, 15 Apr 2009 13:13:13 GMT

Beginner, using IP 2003

I have several date pickers on a form, and a text box at the end of the form.

I need that text box to display the lowest date from all the date pickers on my form.