Date comparison :: Condition not working

[SenthilD]

Hi All,
I have a scheduled report, which sends out an email with list of sale transactions happened on previous day. This was working fine till Nov 2nd. But after that, it sends out a email with empty list and appears to be failing at date check condition validation. The report doesn’t have any other filter condition. If i remove the condition it send a list.

I’m using google sheet as data source with locale as India-English.

Given below the condition.
<<Start: Select(vanDelivery[_ComputedKey], DATE([txnDate])=DATE(TODAY()-1))>>

Please help.

Regards,
Senthil