<div>
I don't know if I can help, but FWIW:<br />
<br />
&nbsp;I don't see any screenshots, or anything else, attached to your post.<br />
<br />
&nbsp;You posted this in the MS SQL section. &nbsp;Is DATE_ADD an MS SQL function? &nbsp;It wasn't in the past, but maybe it's been added. &nbsp;From a little searching I did, DATE_ADD seems to be a MySQL function, so maybe this should be in the MySQL zone?<br />
<br />
&nbsp;Apart from that, your syntax seems OK, so I don't know why you'd be getting an error. &nbsp;I assume that ARVLDATE is a date or datetime column, and if it wasn't, I'd expect an error on that, not the 2.<br />
<br />
&nbsp;Any chance you're using MS SQL and actually using DATEADD, instead of DATE_ADD? &nbsp;The DATEADD arguments would be:<br />
&nbsp; <br />
DATEADD(day, 2, ARVLDATE)<br />
<br />
&nbsp;James
</div>


I don't know if I can help, but FWIW:

 I don't see any screenshots, or anything else, attached to your post.

 You posted this in the MS SQL section.  Is DATE_ADD an MS SQL function?  It wasn't in the past, but maybe it's been added.  From a little searching I did, DATE_ADD seems to be a MySQL function, so maybe this should be in the MySQL zone?

 Apart from that, your syntax seems OK, so I don't know why you'd be getting an error.  I assume that ARVLDATE is a date or datetime column, and if it wasn't, I'd expect an error on that, not the 2.

 Any chance you're using MS SQL and actually using DATEADD, instead of DATE_ADD?  The DATEADD arguments would be:
 
DATEADD(day, 2, ARVLDATE)

 James

<div>
If &nbsp;you are using mysql as James indicated, then the syntax you are using should work.<br />
<br />
If however, you are using SQL Server, then date_add is not a valid sql server syntax.<br />
<br />
dateAdd(day, 2, ARVLDATE)
</div>


If  you are using mysql as James indicated, then the syntax you are using should work.

If however, you are using SQL Server, then date_add is not a valid sql server syntax.

dateAdd(day, 2, ARVLDATE)

<div>
<div class="content wysiwyg-content">
I am trying to add an expression to a BI container.<br />
DATE_ADD(ARVLDATE,INTERVAL<wbr /> 2 DAY)<br />
this continues to return an error of &quot;incorrect syntax near '2'<br />
screen shots attached
</div>
</div>


I am trying to add an expression to a BI container.
DATE_ADD(ARVLDATE,INTERVAL 2 DAY)
this continues to return an error of "incorrect syntax near '2'
screen shots attached

Date_Add or Date_Sub

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.