Runtime error yet all data items validated with no error

[que1983]

I created a date item called [File Received Dt Beg]
cast([Presentation Layer].[POST CLOSING].[File Received Date]as date)>='2015-09-01'

I created a date item called [NM]
_first_of_month(_add_months (current_date;+1))


I created another data item called pipe_total
(case when [File Received Dt Beg]<[NM] and [Channel Code]='CO' then[Loan Number] else (NULL) end)

I validated all items an get no validation errors

I added pipe_total to my page 1  When I run it I get an sql error
   Data source adapter error: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near '<'. - when processing query: SELECT

[navissar]

I created a date item called [File Received Dt Beg]
cast([Presentation Layer].[POST CLOSING].[File Received Date]as date)>='2015-09-01'

This will return true or false (because it's a comparison: Is this date larger than or equal to September 1st 2015.

I created a date item called [NM]
_first_of_month(_add_months (current_date;+1))

there's an unnecessary semi colon there.

[que1983]

The date for _first_of_month(_add_months (current_date,+1)) or [NM] is supposed to generate the first day of next month and I need to compare it to another date,  I replaced the semi colon with a comma and still get a runtime error.  So is there a problem with my syntax to get the first day of next month?

[que1983]

In other words I need to hard code cast([Presentation Layer].[POST CLOSING].[File Received Date]as date)>='2015-09-01'  I only want the File Received date if it is >= 2015-09-01.  I then want to compare it to the Next month date that I mentioned earlier

[que1983]

Think I figured it out.  Thanks for the information.  I need to add a Boolean to capture any date >=2015-09-01