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



      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