time bracket

[joeybird]

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

[robert_mika · Accepted solution]

If I understand this correctly:

IF 1/2=12 hours

then 7 days*24=168 hours

[joeybird]

Hiya

brill!

thanx

kind regards

joeybird