Date Calculation

  • Thread starter Thread starter DEI
  • Start date Start date
D

DEI

I am working on a database that keeps track of tuition
assistance reimbursement. We disburse tuition assistance
according to an academic year instead of the calendar year
(8/1/yyyy through 7/31/yyyy).

I would like to create unbound control in a form that
totals values assigned dates within the current academic
year, which spans from August 1 through July 31.

I am trying to use calculations based on the current date,
but haven't come up with anything.

How can I get access to define a date range from August 1
to July 31st without resetting the date parameters? Is
there a better way to go about this?

Thank you for your assistance.
 
I think what your looking for is utilization of the
DateSerial Function. Try this.

Between DateSerial( Year , Month , 1) And DateSerial(
Year , Month , Day )

Frank
 
I am working on a database that keeps track of tuition
assistance reimbursement. We disburse tuition assistance
according to an academic year instead of the calendar year
(8/1/yyyy through 7/31/yyyy).

I would like to create unbound control in a form that
totals values assigned dates within the current academic
year, which spans from August 1 through July 31.

I am trying to use calculations based on the current date,
but haven't come up with anything.
Click to expand...

Use a calculation such as

BETWEEN DateSerial(Year(Date()) - IIF(Month(Date() > 7, 0, 1), 8, 1)
AND Date()

as a criterion to get all records since the start of the previous
fiscal year.
 
Back
Top