Find the first date from several date pickers - InfoPath Dev
in

InfoPath Dev

Find the first date from several date pickers

Last post 04-30-2009 07:04 AM by Crazy Vinnie. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 04-15-2009 06:13 AM

    Find the first date from several date pickers

    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.

  • 04-19-2009 05:40 PM In reply to

    Re: Find the first date from several date pickers

    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.

    Hilary Stoupa

  • 04-30-2009 07:04 AM In reply to

    Re: Find the first date from several date pickers

    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.

Page 1 of 1 (3 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.