Report Calculation - Number of Weeks betwen 2 Dates?

  • Thread starter Thread starter Todd D. Levy
  • Start date Start date
T

Todd D. Levy

IF I have fields in a report that are a Start Date and an End Date
for a period of time, can I have a calculation of the number of week
that this time period encompasses?
 
Todd D. Levy said:
IF I have fields in a report that are a Start Date and an End Date
for a period of time, can I have a calculation of the number of week
that this time period encompasses?
Click to expand...

Check help file for DateDiff() function.

NOTE: DateDiff counts "boundaries crossed" so a DateDiff of weeks between Saturday
night and Sunday morning will be one. This often means that you have to use a
smaller interval for the DateDiff and then divide to get the value you want.
 
Back
Top