Ciao a tutti.

Se ho questa data: 2006/09/04 in MySQL

e devo ottenere i 5 giorni successivi:

codice:
j = Weekday(cDate(strDUEDATE)) 
x =   WeekdayName(Weekday(cDate(strDUEDATE)))

for i = 0 to datediff("d",cDate(strDUEDATE),cDate(strDUEDATE2))

   strDUEDATE = dateadd("d", cDate(strDUEDATE), i)

next
Perchè risponde con:

Tipo di errore:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E31)
[MySQL][ODBC 3.51 Driver][mysqld-5.0.24-community-nt]Incorrect date value: '-2011' for column 'DueDate' at row 1

:master: