Controls

Re: Displaying a Message based on what date is selected

Michael71 — Thu, 28 Jan 2010 20:02:53 GMT

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!

Re: Displaying a Message based on what date is selected

Michael71 — Thu, 28 Jan 2010 16:48:02 GMT

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

Re: Displaying a Message based on what date is selected

Jimmy — Thu, 28 Jan 2010 15:33:06 GMT

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.

Re: Displaying a Message based on what date is selected

Michael71 — Thu, 28 Jan 2010 15:15:10 GMT

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)), "")

Re: Displaying a Message based on what date is selected

Qazi Anis — Thu, 28 Jan 2010 05:38:53 GMT

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

Displaying a Message based on what date is selected

Michael71 — Wed, 27 Jan 2010 20:41:03 GMT

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