I am trying to run a conditional SQL statement to append info from one table to another where the Date in the DateField is >Todays but <Today+7.
I am using getdate() but i keep getting this error:
Undefined function 'getdate' in expression.
/DIGFootball/Admin/FriDiv3/update2.asp, line 143
[Line 142 =] sql6 = "Insert Into tblWeeklyFixtures_Div3 Select * From tblAllFixtures_div3 Where GameDate between getdate() and getdate()+7"
[Line 143 =] conn.execute(sql6)
I take it this error occurs because i need to convert the date format of Getdate() to (dd/mm/yyyy) but i dont know how to do this. does anyone know how to do this and where i would need to put it?
Thanks for taking the time to read this