Use "Yesterday before 2pm" in a case statement

Reply
Highlighted
Orange 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
Highlighted
Orange 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!

View solution in original post


All Replies
Highlighted
Orange 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!

View solution in original post

Announcements
Coming Soon: Weekly Virtual User Meet-ups to answer all your questions! Stay tuned for more details to come this week.