Hi @satichun,
Welcome back.
So I’ve got a few questions for you.
- when you say yesterday, do you mean from TODAY()? or from the Last Refresh Date? or MAX transaction date?
- you are always comparing single days, correct?
- how will you handle yesterday vs last month, when there is no date value in the prior month like for a 31st?
Here are some resources you might find helpful in the meantime:
https://forum.enterprisedna.co/t/the-best-time-comparison-function-dateadd/4927