Change yesterday vs day before, yesterday vs last week, yesterday vs last month

Hi @satichun,

Welcome back.

So I’ve got a few questions for you.

  1. when you say yesterday, do you mean from TODAY()? or from the Last Refresh Date? or MAX transaction date?
  2. you are always comparing single days, correct?
  3. 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