InfoPath Dev

Works perfectly. Thanks Hillary!

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 ...

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

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 ...