yesterday statement

Hot Topic

Custom Code for a Parameter
Error when connecting to server via SQL 2005 Management Studio in Object Explorer but not Query Window
How can I get the Error description in SQL Execute Task
storedproc return
Permissions needed to Restore a DB using SMO
Can't get to report manager home page.
Restore fails
Excel Numbers format
Getting T-SQL code for a stored procedure
Calculated Cell

SQL Server

rounding numerics
I need a duplicate "empty" database created from an existing "populated" with data. sql 2005
Problems with the SELECT ROW_NUMBER() OVER approach
Cannot connect to a default Express instance
Login to SQL Server Express using Command Prompt
RS 2000 Report Designer Install
Newbie Basic Question - DISTINCT & PKs
Management Studio on client
Report from prcedure that return multiple recordsets
IE7 from Windows Update - SRS no longer works

yesterday statement

Hi,

I am trying to substract one day from my current date and are having difficulties any suggestions

=IIF(Fields!DOCDATE.Value = today-1 and Fields!SOPTYPE.Value =3,Fields!XTNDPRCE.Value,

IIF(Fields!DOCDATE.Value = today-1 and Fields!SOPTYPE.Value =4,-(Fields!XTNDPRCE.Value),"0"))

Answer this question

yesterday statement

Ying06
Thx a stack
Finch82

The following expression calculates 'Yesterday':
=Today.AddDays(-1)

-- Robert
yesterday statement

Answer this question