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 list archives
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