https://netsuiteprofessionals.com logo
n

neerajrtiwari

01/26/2017, 11:25 PM
I am trying to put a formula to give a count of all orders whose ship date is until Jan 31. I am using CASE for this purpose. The best I can do is: CASE WHEN {shipdate} BETWEEN ({today}-365) AND ({today}+7) THEN 1 ELSE 0 END