Subtracting Days from a Date

P

pcap

Between [Forms]![Hours Query]![End Date] And ([Forms]!
[Hours Query]![End Date]-14)

This worked before I did the Upsize wizard and loaded my
tables on SQL Server. Now it does not work. When I take
out the 14 it returns data. Basically I am taking a date
from a form and getting the date range of that date and 14
days before. Any ideas?
 
D

Dale Fye

How about:

Between [Forms]![Hours Query]![End Date]
And DateAdd("d", -14, [Forms]![Hours Query]![End Date])

--
HTH

Dale Fye




This worked before I did the Upsize wizard and loaded my
tables on SQL Server. Now it does not work. When I take
out the 14 it returns data. Basically I am taking a date
from a form and getting the date range of that date and 14
days before. Any ideas?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Display weeks from a Milestone 0
query on date 1
query to show where no data in a stated column 0
Creating a dynamic chart range where the range to be graphed depends on the contents of a cell 0
query help 2
Adding data to MS Access from csv file 0
Unable to use filter in datasheet view or add criteria to query indesign view 2
how do i not count weekend days in an access querry 0

Top