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
Quote from: que1983 on 30 Apr 2016 05:42:05 PM
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.
Quote from: que1983 on 30 Apr 2016 05:42:05 PM
I created a date item called [NM]
_first_of_month(_add_months (current_date;+1))
there's an unnecessary semi colon there.
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?
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
Think I figured it out. Thanks for the information. I need to add a Boolean to capture any date >=2015-09-01