DateDiff Function

Returns the number of date or time intervals between two given date values.

Syntax:


DateDiff (interval As String, date1 As Date, date2 As Date [, firstDayOfWeek As Integer [, firstWeekOfYear As Integer]]) As Double

āĻĒā§āϰāĻĻāĻžāύ āĻŽāĻžāύ:

āĻāĻ•āϟāĻŋ āϏāĻ‚āĻ–ā§āϝāĻžāĨ¤

Parameters:

interval - A string expression from the following table, specifying the date or time interval.

interval (string value)

āĻŦā§āϝāĻžāĻ–ā§āϝāĻž

yyyy

āĻŦāĻ›āϰ

q

āϚāϤ⧁āĻ°ā§āĻĨāĻžāĻ‚āĻļ

m

āĻŽāĻžāϏ

y

āĻŦāĻ›āϰ⧇āϰ āĻĻāĻŋāύ

w

āĻ•āĻ°ā§āĻŽāĻĻāĻŋāĻŦāϏ

ww

āĻŦāĻ›āϰ⧇āϰ āϏāĻĒā§āϤāĻžāĻš

d

āĻĻāĻŋāύ

h

āϘāĻ¨ā§āϟāĻž

n

āĻŽāĻŋāύāĻŋāϟ

s

āϏ⧇āϕ⧇āĻ¨ā§āĻĄ


date1, date2 - The two date values to be compared.

Date literals allow to specify unambiguous date variables that are independent from the current language. Literals are enclosed between hash signs #. Possible formats are:

firstdayofweek: An optional parameter that specifies the starting day of a week.

firstdayofweek value

āĻŦā§āϝāĻžāĻ–ā§āϝāĻž

0

āϏāĻŋāĻ¸ā§āĻŸā§‡āĻŽā§‡āϰ āĻĄāĻŋāĻĢāĻ˛ā§āϟ āĻŽāĻžāύ āĻŦā§āϝāĻŦāĻšā§ƒāϤ āĻšā§Ÿ

1

āϰāĻŦāĻŋāĻŦāĻžāϰ (āĻĄāĻŋāĻĢāĻ˛ā§āϟ)

2

āϏ⧋āĻŽāĻŦāĻžāϰ

3

āĻŽāĻ™ā§āĻ—āϞāĻŦāĻžāϰ

4

āĻŦ⧁āϧāĻŦāĻžāϰ

5

āĻŦ⧃āĻšāĻ¸ā§āĻĒāϤāĻŋāĻŦāĻžāϰ

6

āĻļ⧁āĻ•ā§āϰāĻŦāĻžāϰ

7

āĻļāύāĻŋāĻŦāĻžāϰ


firstweekofyear: An optional parameter that specifies the starting week of a year.

firstweekofyear value

āĻŦā§āϝāĻžāĻ–ā§āϝāĻž

0

āϏāĻŋāĻ¸ā§āĻŸā§‡āĻŽā§‡āϰ āĻĄāĻŋāĻĢāĻ˛ā§āϟ āĻŽāĻžāύ āĻŦā§āϝāĻŦāĻšā§ƒāϤ āĻšā§Ÿ

1

āĻŦāĻ›āϰ⧇āϰ ā§§āĻŽ āϏāĻĒā§āϤāĻžāĻšāϟāĻŋ āĻšāϞ⧋ ā§§āϞāĻž āϜāĻžāύ⧁⧟āĻžāϰāĻŋ āϏāĻŽā§āĻŦāϞāĻŋāϤ āϏāĻĒā§āϤāĻžāĻš (āĻĄāĻŋāĻĢāĻ˛ā§āϟ)

2

āϏāĻĒā§āϤāĻžāĻš ā§§ āĻšāϞ⧋ āϏ⧇āχ āĻŦāĻ›āϰ⧇āϰ āϚāĻžāϰ āĻ…āĻĨāĻŦāĻž āϤāϤ⧋āϧāĻŋāĻ• āĻĻāĻŋāύ āĻŦāĻŋāĻļāĻŋāĻˇā§āϟ āĻĒā§āϰāĻĨāĻŽ āϏāĻĒā§āϤāĻžāĻš

3

āϏāĻĒā§āϤāĻžāĻš ā§§ āĻšāϞ⧋ āύāϤ⧁āύ āĻŦāĻ›āϰ⧇āϰ āĻļ⧁āϧ⧁āĻŽāĻžāĻ¤ā§āϰ āĻĻāĻŋāύ āĻŦāĻŋāĻļāĻŋāĻˇā§āϟ āĻĒā§āϰāĻĨāĻŽ āϏāĻĒā§āϤāĻžāĻš


Example:


Sub example_datediff
    MsgBox DateDiff("d", #1/1/2005#, #2005-12-31#)
End Sub

Please support us!