OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
Re: Statement for a date range

dpgiragomdanderson.org
Date: Thu Jan 31 2008 - 13:58:30 CST

> 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;