Need help to figure out simple date filter in calculation view
Guys and Gals,
I have a simple issue that I can't wrap my little brain around.
I need a simple date filter where I get data for only yesterday. For example ERDAT = yesterday.
This has to be done in the expression editor in the first projection node, I want to force this filter on the attribute view so the performance will be great. Putting a filter in the first projection node where you consume the Attribute view is equivalent to putting that filter directly in the Attribute view (please correct me if I'm wrong but I'm 99% sure and tested it).
So my basic filter in the expression editor will be:
ERDAT = now() -1
Sounds simple enough but doesn't it? Can someone please tell me the syntax where I only get yesterday's date?
Note: If the answer is create a calculated column, etc., then I am not enforcing the filter on the attribute view right away.
Thanks alot experts.