Use "Yesterday before 2pm" in a case statement

Hello all!


I'd like to use "yesterday at 2pm" in a case statement.  How do I write out that condition?


The case statement would look a bit like this.


Case when 'date' < "Yesterday at 2pm" then 'yes' else 'no' end

Appreciate any help.

Best Answer

  • colinr
    Answer ✓

    I came up with 



    Let me know if you have anything better!