Home > database >  Return a specific value 'Open' where days are between Monday - Friday and time is >=8:0
Return a specific value 'Open' where days are between Monday - Friday and time is >=8:0

Time:10-14

Return a specific value 'Open' where days are between Monday - Friday and time is >=8:00 & <19:00 all other days and times should return 'OOH'

Open = >=8:00 & <19:00 & Monday to Friday inclusive OOH = >=19:01 & <7:59 & Monday to Friday & anytime on Saturday or Sunday

enter image description here

  • Related