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 -- 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: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]