<div>
CLARITY_TDL_AGE.POST_DATE &lt;&nbsp;SELECT DATEADD(DAY, 1 - DAY(GETDATE()), DATEDIFF(DAY, 0, GETDATE()))
</div>


CLARITY_TDL_AGE.POST_DATE < SELECT DATEADD(DAY, 1 - DAY(GETDATE()), DATEDIFF(DAY, 0, GETDATE()))

<div>
Nope, sorry. &nbsp;It keeps saying the ) is missing where the word GETDATE is.
</div>


Nope, sorry.  It keeps saying the ) is missing where the word GETDATE is.

<div>
&gt;&gt;The code acperkins provided is for use in SQL Server.&lt;&lt;<br />
Exactly, I thought that is what they meant by &quot;How can I say that in Sequel?&quot;<br />

</div>


>>The code acperkins provided is for use in SQL Server.<<
Exactly, I thought that is what they meant by "How can I say that in Sequel?"


<div>
Although on second thoughts it should have been:<br />
CLARITY_TDL_AGE.POST_DATE &lt;&nbsp;DATEADD(DAY, 1 - DAY(GETDATE()), DATEDIFF(DAY, 0, GETDATE())) 
</div>


Although on second thoughts it should have been:
CLARITY_TDL_AGE.POST_DATE < DATEADD(DAY, 1 - DAY(GETDATE()), DATEDIFF(DAY, 0, GETDATE()))

<div>
 Just another option for CR:<br />
<br />
Date ({CLARITY_TDL_AGE.POST_DAT<wbr />E}) &lt;&nbsp;Date (Year (CurrentDate), Month (CurrentDate), 1)<br />
<br />
<br />
&nbsp;James<br />

</div>


Just another option for CR:

Date ({CLARITY_TDL_AGE.POST_DATE}) < Date (Year (CurrentDate), Month (CurrentDate), 1)


 James


<div>
Thanks everyone for your help!. &nbsp;Sorry I wasn't clear on needing Crystal syntax. &nbsp;The first one mimcc provided worked perfectly, so I haven't tried the others but I will keep all in reserve.<br />
<br />
You are all awesome. &nbsp;You make me look so good!
</div>


Thanks everyone for your help!.  Sorry I wasn't clear on needing Crystal syntax.  The first one mimcc provided worked perfectly, so I haven't tried the others but I will keep all in reserve.

You are all awesome.  You make me look so good!

<div>
<div class="content wysiwyg-content">
I need a filter that gives me all transactions posted prior to the first day of the current month.<br />
I am going to place this in the record selection of a Crystal 2008 Report.<br />
How can I say that in Sequel?<br />
<br />
The field is a DATE field. &nbsp;<br />
<br />
Date({CLARITY_TDL_AGE.POST<wbr />_DATE}) &lt;&nbsp;First day of current month
</div>
</div>


I need a filter that gives me all transactions posted prior to the first day of the current month.
I am going to place this in the record selection of a Crystal 2008 Report.
How can I say that in Sequel?

The field is a DATE field.  

Date({CLARITY_TDL_AGE.POST_DATE}) < First day of current month

T-Sql DATE Question

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.

Microsoft SQL Server

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.