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?
If I understand this correctly:
IF 1/2=12 hours
then 7 days*24=168 hours
Retrieving data ...