InfoPath Dev

Hi, Newbie here and currently working on infopath designer 2013 to customize my sharepoint 2010 list. I have a calculated column name '"status" that will return a value of " Current " or " Expired" based on the data entered on the column name Expiration Date. Formula on the Status column is =IF([expiration date]

Did part of your formula cut off? I think you are saying that when you modify the list form in InfoPath, something stops working in your calculated column?

Hi Hillary,

This is the  formula I used in SP2010. But when I tried to modify form in InfoPath i'm getting a syntax error for the formula below.

Thanks for the reply. Appreciate very much.!!  

 =IF([expiration date]<Today,"Expire","Current")

You'll probably need to instead use a rule on the Expiration Date field. So in InfoPath Designer, on the Expiration date, you'd add two rules. One have the condition that if the date is less than today (use a formula, then use the today function) set the field that needs the value to Expire. The other rule, also on the expired field, would be if the date is greater than or equal to today, set the field to Current. HOWEVER - that would only run when the expiration date changes.... So - I'm wondering if what you really need here is SharePoint workflow?

Hi Hilary, Please see attached form sample. The certificate status field with have a return value of either Current or Expired, based on the expiration date field. IF the expiration date is less than the today's date the return value in the status field is expired, and current if its equal or more than todays date. I tried the formula that i created in SP10 but im getting a error, Could you please provide the correct formula. So sorry i'm just starting with SP and infopath. I don't know if this is possible, but your help is much appreciated

Rules are on form load and field 2. Save the form locally, right click design and preview.

Works perfectly. Thanks Hillary!