InfoPath 2007. How to do an if Statement in an infopath form to calculate a value.

Posted on 2009-02-10
Last Modified: 2012-06-21
Browser-based form. I want people to fill out an expense form. There is an ExpenseDate field, a Mileage field, and a Mileage Allowance field.  If the ExpenseDate is < 1/1/2009 then I need the MileageAllowance field to show Mileage * 0.585  else Mileage * 0.55.

InfoPath doesn't use straightforward if statements. Please help.
Question by:CLP-ITT
    LVL 25

    Accepted Solution

    Have a look at the screenshots. It's easier than you think.
    I did it in the rules of the date field so the event fires when a date is entered.


    Author Closing Comment

    Thank you! I'm new to InfoPath (obviously) and that was exactly what I needed.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    I used to be SharePoint evangelist in our company, so my Outlook always full of questions about how to do this, or where I can find that. One day I found such an email with the following question: "how to attach 3-State workflow (one of the workflow…
    SharePoint Designer 2010 has tools and commands to do everything that can be done with web parts in the browser, and then some – except uploading a web part straight into a page that is edited in SPD. So, can it be done? Scenario For a recent pr…
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    how to add IIS SMTP to handle application/Scanner relays into office 365.

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    9 Experts available now in Live!

    Get 1:1 Help Now