Records under/over 3 days old

[gbnz]

I am working on determining records that are under or over 3 days old. I just can't seem to get the syntax for Access correct.

Here is my SQL query for greater than 3 days:

SELECT * 
FROM
    AFETaskView
WHERE
    Created < DATEADD(day, -3, getdate())

I just can't seem to work it out for Access which doesn't recognize the "getdate" function.

Thanks
gbnz

 

[plog]

There is no getdate() in Access, to return the current date you would use Date(). Your first argument in your DateAdd is incorrect as well: https://www.techonthenet.com/access/functions/date/dateadd.php. Lastly, if you want over and under a certain timeframe, the < operator alone isn't going to do it.

 

[gbnz]

Thanks for the link. Are you sure this won't work?

SELECT *
FROM dbo_AFETaskView
WHERE (((dbo_AFETaskView.StatName)="In Progress") AND ((dbo_AFETaskView.Created)<=DateAdd("d",-3,Date())));

Because I am receiving the desired result.

 

[The_Doc_Man]

You will get the desired result when the format of the ![Created] field is a date.

If it is not then you are lucky in the way it is working and you could expect to fail across month boundaries.

 

[plog]

You wrote this:

are under or over 3 days old

Which is logically equivalent to saying "are not 3 days old". The code you have written satisfies this statement:"less than or equal to 3 days old".

 

[gbnz]

You wrote this:



Which is logically equivalent to saying "are not 3 days old". The code you have written satisfies this statement:"less than or equal to 3 days old".

Sorry my mistake. I meant 2 different queries and should have stated that.

Thanks for the help.