SQL Where Clause Help with Later of Date
Posted on 2014-04-24
I have 3 dates that will appear in a report. They are: Inv Date, Inv Eff Date and Entered Date.
I need the report to only pull back the line item that has a later date of the three dates that fit the report parameters.
Inv No Prem Comm Pol No Inv Date Inv Eff Date Entered Date
1336496 (12.00) (1.50) BCV064 4/10/2014 3/1/2014 4/10/2014
Right now I run the report in another tool with the report date parameters as follows:
Inv Date >=3/1/2014 and Inv Date<= 3/31/2014
Inv Eff Date >=3/1/2014 and Inv Eff Date<= 3/31/2014
Entered Date >=3/1/2014 and Entered Date<= 3/31/2014
As a result of my dates, I get the above transaction. However, the LATER DATE is 4/10/2014 and I want it NOT to show.