InfoPath Dev

1. I have a date picker in a repeating table and a text field.

2. I want to display a message in the text box, based on the date I chose in the date picker.

3. If the date falls in the 1st Quarter- message 1

4. If the date falls in the 2nd Quarter - message 2 

5. If the date falls in the 3rd Quater - message 3

6. If the date falls in the 4th Quarter - message 4

use rules on the date picker to set the value of text box.

I've done that but it still won't work. Can you tell me why the below syntax don't work.

Condition

Date  Begins with "1"  or

Date Begins with "2"   or

Date Begins with "3" 

Action

=fx Set a Field's value

Field = Quarter

Value = concat("LEAP Quarter 1 ", number(substring(., 1, 4)), "")

 XML dates are always in the format YYYY-MM-DD, so the month is represented in the 6th and 7th characters.  The way you have it set up now, your rule is just looking at the first character, which is the first digit of the year.

What do you recommend that I do so that it works?

I figured it out. Just write a rule if date contains -01-  or  -02-  or   -03-  set field = Quarter 1

                                                                   -04-   or  -05-  or  -06-  set field = Quarter 2  and so on

The Date picker will never contain more that one date of the month with the " - " on bothe sides!