SOLVED: Date query

Hey just need help with a date query. I'm trying to pull the Calls from yesterday, how would this rule change?

FIND Calls WHERE DATE_PART(Calls.TimeOfCall)=DATE_PART(CURRENT_TIMESTAMP) AND HOUR(Calls.TimeOfCall)>=8 AND HOUR(Calls.TimeOfCall)<=17

Also, is there a reference somewhere for date stuff? I always struggle with those.

Hi Mark,

If you just want to see all the calls for the previous day I Think you could try:

FIND Calls WHERE DATE_PART (Calls.TimeOfCall)=DATE_ADD(CURRENT_DATE, -1)

Hope this helps.

kind regards

Oh I had tried that without the comma! Thanks!