InfoPath Dev

I have two fields. One displays a created date. The second is an expression field that looks at the created date, adds 30 days and displays that date. What I want is for the expression box to go red if the count is 31 days or more. What is the best way to accomplish this?

You need to add conditional formatting to your date picker.  The formula you will use will look something like if date1 < addDays(date2, -30).  You'll have to play around with the number to get it exactly how you want it, but that's the general idea.

Thank you for your explanation. Sadly, I am still struggling a bit. Perhaps a little more explanation may be helpful.

• Created: (Expression Box) concat(substring(@Created, 6, 2), "/", substring(@Created, 9, 2), "/", substring(@Created, 1, 4)) 
• Expired: (Expression Box) addDays(@Created, 30)

Within the Expired box I am adding the Condition. It seems I can either get the font to always be black (default) or always red. :(  The always red setting is configured as follows;

If this Condition is true:
  Created      Is Greater Than    adddays(@created, -30)

 I've got to be close, it's just not seeing or utilizing the date. It should only go red on the 31'st day.  

What exactly are you using to create your date field?  In my formula all you need is just a simple date for it to work.  You don't need to parse the different parts separately.

It's pulling the created date from a SharePoint list. I had to set it up this way because in a new form, there is no created date. So the field is hidden. However, if after its creation the form is opened by a user, the created field is displayed. Then there is the Expiration field. It too has the same hidden condition because with a new form there is no expiration. Again, once opened it displays a Created Date + 30 days value. What I am trying to do is have it display, but on the 31st day, make it go red.

 

Hope that better explains things.

Then it should just work if you use that date directly from SharePoint instead of parsing it the way you do.  Try that and see if that works for you now.

I apologize, I follow what you are saying, just not sure how to write it. Would it be something like (@Created) +31. I tried this, and it passes the formula checker but it does not make it go red.

Sure I can walk you through it.  I'm assuming both are date fields that are bound to date pickers.  Here's what you need to do:

1. Click on the first date picker.
2. Open up the Rules Manager (Home -> Manage Rules)
3. Add a validation rule.
4. Click on the condition which will bring up a dialog
5. For the left dropdown, select the first date field.
6. For the middle dropdown, select is less than.
7. For the right dropdown, select use a formula.
8. Click Insert Function --> Date category -0> addDays --> OK
9. Double click on the first field and select the second date.
10. Double click on the second field and type in "-30".
11. OK out of all the dialogs
12. Make sure you enter a ScreenTip otherwise the rule won't work.

Hope this helps!

Thank you very much for the detailed instructions, but sadly, these are expression boxes. I can't select them from the AddDays picker. Maybe I need to approach this from a different perspective. Should I create a text field and then try to associate it?

The concept should be similar with an expression box.  Instead of using a validation rule, you can use the formatting rule the same way and make the background red or something.  Sorry I'm not sure what your exact scenario here is, so I'm making a few assumptions in my explanations :)

 Thanks, worked for me.