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?
 
Back
Top