Subtracting Days from a Date

  • Thread starter Thread starter pcap
  • Start date Start 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?
 
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

query on date 1
subtract days from a date 2
Excel High lightng dates in future, today and past 1
Date calculation 2
Workday Formula to include date 0
Date subtraction 3
Cross tab query solution 4
query help 2

Back
Top