DateAdd function (1 Viewer)

[LEXCERM]

Hi All,

I've been using the DateAdd function to great effect, but am stumped on a solution for this problem.

I have a table full of dates which run in sequence, i.e. 1/9/15, 2/9/15, 3/9/15 and so on.

I require a query to show me dates for just every two weeks starting from the 1/9/15, i.e. 1/9/15, 15/9/15, 29/9/15 and so on.

Thanks in advance.

Regards.

 

[namliam]

Something like this should work:

Select *
from yourtable
where (Yourdatefield - #09/07/2015#) / 14 = int((Yourdatefield - #09/07/2015#) / 14)

 

[LEXCERM]

That's awesome namliam!

Thanks very much for your quick reply.