> 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
>
to January 31, 2008, I want that to appear like that on the report,
but how?
Mike
--
View this message in context:
http://www.nabble.com/Statement-for-a-date-range-tp15212948p15212948.html
Sent from the MySQL - General mailing list archive at Nabble.com.
--
MySQL General Mailing List
For l
