October 11th, 2013, 12:38 AM
Deleting from a table when a date is greater than input
Hello everybody, I'm using Access database, and I control it by using sql in vb.net.
I have a date field in a table and I need to delete from that table where the field date is greater than the input date in the vb form.
I tried using the datediff() and delete where the function retrieves negative value, but it tells me that I have missing arguments, I guess it's the time.
The date field is DD/MM/YYYY. No time in it.
Please help me in this query.
October 11th, 2013, 03:52 AM
a simple comparison should do it
Originally Posted by Erez_Ko
WHERE datefield > '#inputdate#'
October 11th, 2013, 08:27 AM
Oh I didn't knowbi have to put the '#' sign.. Thanks a lot!