DateAdd Function
āĻāĻāĻāĻŋ āĻĒā§āĻ°āĻĻāĻ¤ā§āĻ¤ āĻ¤āĻžāĻ°āĻŋāĻā§ āĻā§ā§āĻāĻŦāĻžāĻ° āĻ¤āĻžāĻ°āĻŋāĻā§āĻ° āĻŦāĻŋāĻ°āĻ¤ā§ āĻ¸āĻāĻ¯ā§āĻāĻ¨ āĻāĻ°āĻž āĻšā§ āĻāĻŦāĻ āĻĢāĻ˛āĻžāĻĢāĻ˛ā§āĻ° āĻ¤āĻžāĻ°āĻŋāĻ āĻĒā§āĻ°āĻĻāĻžāĻ¨ āĻāĻ°ā§āĨ¤
āĻ¸āĻŋāĻ¨āĻā§āĻ¯āĻžāĻā§āĻ¸:
DateAdd (Add, Count, Date)
āĻĒā§āĻ°āĻĻāĻžāĻ¨ āĻŽāĻžāĻ¨:
āĻ¤āĻžāĻ°āĻŋāĻ āĻ§āĻžāĻ°āĻŖāĻāĻžāĻ°ā§ āĻāĻāĻāĻŋ āĻā§āĻ°āĻŋā§ā§āĻ¨ā§āĻāĨ¤
āĻĒā§āĻ¯āĻžāĻ°āĻžāĻŽāĻŋāĻāĻžāĻ°:
Add - A string expression from the following table, specifying the date interval.
|
āĻ¸āĻāĻ¯ā§āĻāĻ¨ (āĻ¸ā§āĻā§āĻ°āĻŋāĻ āĻŽāĻžāĻ¨) |
āĻŦā§āĻ¯āĻžāĻā§āĻ¯āĻž |
|
yyyy |
āĻŦāĻāĻ° |
|
q |
āĻāĻ¤ā§āĻ°ā§āĻĨāĻžāĻāĻļ |
|
m |
āĻŽāĻžāĻ¸ |
|
y |
āĻŦāĻāĻ°ā§āĻ° āĻĻāĻŋāĻ¨ |
|
w |
āĻāĻ°ā§āĻŽāĻĻāĻŋāĻŦāĻ¸ |
|
ww |
āĻŦāĻāĻ°ā§āĻ° āĻ¸āĻĒā§āĻ¤āĻžāĻš |
|
d |
āĻĻāĻŋāĻ¨ |
|
h |
āĻāĻ¨ā§āĻāĻž |
|
n |
āĻŽāĻŋāĻ¨āĻŋāĻ |
|
s |
āĻ¸ā§āĻā§āĻ¨ā§āĻĄ |
Count - A numerical expression specifying how often the Add interval will be added (Count is positive) or subtracted (Count is negative).
Date - A given date or the name of a Variant variable containing a date. The Add value will be added Count times to this value.
āĻāĻĻāĻžāĻšāĻ°āĻŖ:
Sub example_dateadd
MsgBox DateAdd("m", 1, "1/31/2004") &" - "& DateAdd("m", 1, "1/31/2005")
End Sub