Calculate CA for yesterday

[Anonymous]

I am trying to calculate CA for yesterday , I try the following expression

=Sum({1< [Date Time]={'$(=Date(Today()-1))'}>}[CA TTC] )

there is data in sql server But it returns nothing in qlikview , any suggestion ?

[sinanozdemir]

What is date format of the date field in sql server?

That could be the problem.