Fixed vs. Relative Time Periods

[Guest]

An example of a fixed time period would be July 1, 2005 or Q1 2005, Q2 2005,
etc. Examples of relative time periods would be 12 month rolling to Current
Year, Current Year, Last Year, YTD Current Year, Current Quarter Current
Year, Previous Quarter, 12 month rolling two years ago, and so on.

Does access recognize the difference between fixed vs. relative time
periods? What would the best method be for creating relative time periods?

 

[Duane Hookom]

Dates are like numbers. Weeks, months, quarters, years, etc are like
counting by 5s or 10s or 25s. Relative dates are like subtracting numbers or
adding numbers.

Check the DateAdd() function or other date functions. You may need to be in
a module when bringing up Help.

 

[Marshall Barton]

An example of a fixed time period would be July 1, 2005 or Q1 2005, Q2 2005,
etc. Examples of relative time periods would be 12 month rolling to Current
Year, Current Year, Last Year, YTD Current Year, Current Quarter Current
Year, Previous Quarter, 12 month rolling two years ago, and so on.

Does access recognize the difference between fixed vs. relative time
periods? What would the best method be for creating relative time periods?

A date is a date. A time period is your interpretation of
multiple dates or a start date and a duration.

Check the DateSerial function in Help, you can do a lot to
specify a date relative to another date.

Also check the DateAdd function to addall kinds of durations
to a date.