Use "Yesterday before 2pm" in a case statement

Reply
Highlighted
White Belt

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.


Accepted Solutions
White Belt

Re: Use "Yesterday before 2pm" in a case statement

I came up with 

 

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

Let me know if you have anything better!


All Replies
White Belt

Re: Use "Yesterday before 2pm" in a case statement

I came up with 

 

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

Let me know if you have anything better!

Announcements
Looking for the latest Community solutions? Please visit our accepted solutions board here!