Hi, For any reason, current_date doens't look to behave normally since a few days. I run reports in a MySQL DB through sql queries and I use a statement like " ... invd between current_date - 7 and current_date - 1 ..." It always worked. I just noticed that this week's report was wrong. Indeed : current_date - 7 returns an empty set while current_date - 2 returns the correct date. Current_date - 8 returns an empty set an a warning : "Warning | 1292 | Incorrect date value: '20051199' for column 'invd' at row 1" Current_date -100 returns the 30 last days, current_date - 200 returns the 60 last days. Maybe I'm missing something very basic with the use of current_date, but I really don't understand why current_date - 7 doesn't work anymore. I must say that I upgraded my DB from 4.1 to 5.0 on the 21st of november, but I don't remember having problems with my reports the days after. Does anyone have an idea of the problem ? Thanks in advance.
C.N.
