DateDiff specifics a number of time intervals between two dates. DateDiff (interal,date1,date2,firstdayofweek,firstweekofyear) Interval yyyy = year q = quarter m = month y = day of year d = day w = weekday ww = week h = hour n = minute s = second date1 and date2 are used to calculate the interval firstdayofweek is sunday unless specified firstweekofyear is jan 1 unless specified Weekday returns a number representing the day of the week. Return values are: Sunday = 1 Monday = 2 Tuesday = 3 Wednesday = 4 Thursday = 5 Friday = 6 Saturday = 7 First determine the number of days between the two dates. Calculating the number of work days is done by not adding Saturday and Sunday dates. A query extract from a table containing all the holidays for the year could also be added for increased accuracy.
DateDiff (interal,date1,date2,firstdayofweek,firstweekofyear) Interval
yyyy = year
q = quarter
m = month
y = day of year
d = day
w = weekday
ww = week
h = hour
n = minute
s = second
date1 and date2 are used to calculate the interval
firstdayofweek is sunday unless specified
firstweekofyear is jan 1 unless specified
Weekday returns a number representing the day of the week. Return values are:
Sunday = 1
Monday = 2
Tuesday = 3
Wednesday = 4
Thursday = 5
Friday = 6
Saturday = 7 First determine the number of days between the two dates. Calculating the number of work days is done by not adding Saturday and Sunday dates. A query extract from a table containing all the holidays for the year could also be added for increased accuracy.
你的意思是怎么写?