Member Avatar for amdzw

I need help. :idea:
It's probably something so simple, but is it possible to have a query for "Week Ending"
I.E. if you input a date and it calculates 7 dates before and shows the results. something like
"-7<=[Enter Date]"
instead of using the "Between[Date]And[Date]"
Much Appreciated

  • 2 Contributors
  • 1 Reply
  • 108 Views
  • 1 Month Discussion Span
  • Latest Post Latest Post by harryjo
Member Avatar for harryjo

Daer,

Hopely this will help

In Access, the DateAdd function returns a date after which a certain time/date interval has been added.

The syntax for the DateAdd function is:

DateAdd ( interval, number, date )

interval is the time/date interval that you wish to add. It can be one of the following values:

Value Explanation

yyyy Year
q Quarter
m Month
y Day of the year
d Day
w Weekday
ww Week
h Hour
n Minute
s Second

number is the number of intervals that you wish to add.

date is the date to which the interval should be added.

For example:

DateAdd ('yyyy', 3, #22/11/2003#) would return '22/11/2006'
DateAdd ('q', 2, #22/11/2003#) would return '22/05/2004'
DateAdd ('m', 5, #22/11/2003#) would return '22/04/2004'
DateAdd ('n', 51, #22/11/2003 10:31:58 AM#) would return '22/11/2003 11:22:58 AM'
DateAdd('yyyy', -1, #22/11/2003#) would return '22/11/2002'


Best regards Harry

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.