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

αžŸαŸαž…αž€αŸ’αžαžΈβ€‹αž–αž“αŸ’αž™αž›αŸ‹

០

αž”αŸ’αžšαžΎβ€‹αžαž˜αŸ’αž›αŸƒβ€‹αž›αŸ†αž“αžΆαŸ†αžŠαžΎαž˜β€‹αž”αŸ’αžšαž–αŸαž“αŸ’αž’

៑

αžαŸ’αž„αŸƒβ€‹αž’αžΆαž‘αž·αžαŸ’αž™ (αž›αŸ†αž“αžΆαŸ†αžŠαžΎαž˜)

្

αžαŸ’αž„αŸƒβ€‹αž…αŸαž“αŸ’αž‘

៣

αžαŸ’αž„αŸƒβ€‹αž’αž„αŸ’αž‚αžΆαžš

ៀ

αžαŸ’αž„αŸƒβ€‹αž–αž»αž’

αŸ₯

αžαŸ’αž„αŸƒβ€‹αž–αŸ’αžšαž αžŸαŸ’αž”αžαž·αŸ

៦

αžŸαž»αž€αŸ’αžš

៧

αžŸαŸ…αžšαŸ


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

firstweekofyear value

αžŸαŸαž…αž€αŸ’αžαžΈβ€‹αž–αž“αŸ’αž™αž›αŸ‹

០

αž”αŸ’αžšαžΎβ€‹αžαž˜αŸ’αž›αŸƒβ€‹αž›αŸ†αž“αžΆαŸ†αžŠαžΎαž˜β€‹αž”αŸ’αžšαž–αŸαž“αŸ’αž’

៑

αžŸαž”αŸ’αžŠαžΆαž αŸαŸ‘ αž‚αžΊβ€‹αž‡αžΆβ€‹αžŸαž”αŸ’αžŠαžΆαž αŸβ€‹αžŠαŸ‚αž›β€‹αž˜αžΆαž“ αžαŸ’αž„αŸƒβ€‹αž‘αžΈαŸ‘ αžαŸ‚β€‹αž˜αž€αžšαžΆ (αž›αŸ†αž“αžΆαŸ†αžŠαžΎαž˜)

្

αžŸαž”αŸ’αžŠαžΆαž αŸαŸ‘ αž‚αžΊβ€‹αž‡αžΆβ€‹αžŸαž”αŸ’αžŠαžΆαž αŸβ€‹αž‘αžΈαž˜αž½αž™ αžŠαŸ‚αž›β€‹αž˜αžΆαž“β€‹αž”αž½αž“ αž¬β€‹αž…αŸ’αžšαžΎαž“β€‹αžαŸ’αž„αŸƒβ€‹αž“αŸƒβ€‹αž†αŸ’αž“αžΆαŸ†β€‹αž“αŸ„αŸ‡

៣

αžŸαž”αŸ’αžŠαžΆαž αŸαŸ‘ αž‚αžΊβ€‹αž‡αžΆβ€‹αžŸαž”αŸ’αžŠαžΆαž αŸβ€‹αž‘αžΈαž˜αž½αž™ αžŠαŸ‚αž›β€‹αž˜αžΆαž“β€‹αžαŸ‚β€‹αžαŸ’αž„αŸƒβ€‹αž“αŸƒβ€‹αž†αŸ’αž“αžΆαŸ†β€‹αžαŸ’αž˜αžΈ


Example:


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

Please support us!