Re: Statement for a date range

[dpgirago]

> I have a report that contains a WHERE statement to report on a date 
range in
> Pentaho.
>
> WHERE
> InOut.MOVEMENTDATE >= (CURRENT_DATE - 7)
>
> I want to show on the report what the first date of this range is.  Can
> someone help me with this statement?  So if the last seven days is 
January
> 24, 2008 to January 31, 2008, I want that to appear like that on the 
report,
> but how?
> Mike

select whatever ... where InOut.MovementDate >= ( CURRENT_DATE - 7 )

order by someEntryDateField desc limit 1;