Displaying yesterday's date - Report Studio 1

[elsolo21]

This seems like it should be really easy. How do I display yesterday's date on a report? Right now, I have it as 'Today()' but the data is really as of yesterday.

thanks,
-Eric

 

[blom0344]

_add_days(date,-1) or getdate()-1 for SQL server


Ties Blom

 

[elsolo21]

Ties,

I thought that would be the obvious command but I get "Parsing error on or around position 14 in the expression: "_add_days(date,-1) "" I don't see a typo in there. The getdate command is not recognized. Any other thoughts?

 

[elsolo21]

I got it using "_add_days(date2timestamp(today()),-1)"

There may be an easier way but at least this works.

thanks,
-Eric

 

[blom0344]

Getdate() should work if you are on SQL Server and have included the function set in the package.
To be honest we have seen some pretty strange (= inconsistent) behavior with database native functions.

Ties Blom