Select by todays date (system date) 1

[JONBOY74]

Hi all

I'm trying to do a simple delete where statement using SQL in Access. The problem is that I want to delete everything that is not equal to todays date (system date).

delete from tableA where Input_Date <> SYSTEM DATE

How do I write system date?

HELP

THANKS

Jon

 

[tomschafer]

delete from tableA where Input_Date <> Date()