delete records from datevalue criteria

[enfapro7]

Dear,



i have a problem to delete records from datevalue criteria, i want to delete a whole date but access only delete a date with 0:00 time
DELETE *
FROM KPI_NMS_1
WHERE [Start Time] =DateValue('10/1/2016');

[ItsMe]

Where are you getting the value for your criteria from? You need to pass the time as well as the date. Depending on your regional settings and how/where you get the criteria, this might be something like.
10/1/2016 0:0:0 AM

[enfapro7]

Where are you getting the value for your criteria from? You need to pass the time as well as the date. Depending on your regional settings and how/where you get the criteria, this might be something like.
10/1/2016 0:0:0 AM

thanks,

can i use today() criteria on that table and data type like that?

[ItsMe]

When I look at the screenshot of your table, it seems the data stored was relevant only to the date and not the time. When Access does this, the time is midnight (10/1/2016 0:0:0 AM).

If you use a built in Access function to retrieve the System Date, you will retrieve the Date with the time of midnight. This might be what you are after.

To retrieve the computer's system Date use the Date() function. You can type Date() into the criteria of the Query Designer.

[enfapro7]

When I look at the screenshot of your table, it seems the data stored was relevant only to the date and not the time. When Access does this, the time is midnight (10/1/2016 0:0:0 AM).

If you use a built in Access function to retrieve the System Date, you will retrieve the Date with the time of midnight. This might be what you are after.

To retrieve the computer's system Date use the Date() function. You can type Date() into the criteria of the Query Designer.

Dear ItsMe,

many many thanks its help me a lot

[ItsMe]

Glad to hear.