1 Reply Latest reply on Jul 22, 2016 3:03 PM by hannah.johnson

    Populate results only if days between two dates =XX

    mike.shapiro.0

      I've searched the forum and seen a lot of questions regarding calculating days between two days, but nothing that exactly tackles my calculation I'm trying to create.

       

      I'd like to determine how a product performs based on time lapse between two dates within that products record.  Those dates are [Draft Date] and [Designation Date]

       

      What I'm after is to display [execution] if days between [draft date] and [designation date] = 180 Day or more.  Then same thing for if days between the dates are 90-189 days.

       

      Any guidance or reference is greatly appreciated!