2 Replies Latest reply: Apr 28, 2015 9:25 AM by Joanna Seldon RSS

    time bracket

    Joanna Seldon

      Hiya

       

      I have a time bracket working for 12 hours, but I need to get it to work for weeks

       

      if(([CustomerOrderDateTime] - [CustomerOrderDateTimeComplete]) >= (1/2), 1,0) as [12 Hour Bracket]

       

      how do I change this section  (1/2), to get e.g. 1 week?

       

      Kind Regards

       

      Joeybird