2 Replies Latest reply on Oct 5, 2017 4:20 AM by Subrakant Pradhan

    calculation filed date field if it is less the 14 days from another date field then false

    Michael Dawson

      Hi,

       

      I have the below calculation which works fine but what I would like it to do is = false if [Planned Delivery Date] is less than 14 days than the [Planned Ship Date]

       

      So I guess I will have to re-write [Planned Deliver Date ]<= [Planned Ship Date] THEN "True"

       

      IF [Ordered Qty]=[Commited Qty]THEN"True"ELSEIF [Planned Deliver Date ]<= [Planned Ship Date] THEN "True" ELSEIF [Planned Deliver Date ]>[Planned Ship Date]THEN"False"END