Use "Yesterday before 2pm" in a case statement

colinr
colinr Member
in Magic ETL

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
    colinr Member
    Answer ✓

    I came up with 

     

    timestamp(CURRENT_DATE()-1)+(14/24)

    Let me know if you have anything better!

Answers

  • colinr
    colinr Member
    Answer ✓

    I came up with 

     

    timestamp(CURRENT_DATE()-1)+(14/24)

    Let me know if you have anything better!

Categories