What is the difference between dateadd("d", 10, currentTime) dateadd("w", 10, currentTime)

Question

1.40/5 (3 votes)

See more:

Hi Everyone,

While i was working with classic ASP, I got a doubt that

What is the difference between

dateadd("d", 10, currentTime)
dateadd("w", 10, currentTime)

Both returns the same output. Both adds 10 days to the current datetime.
Is there any scenario where we can see the difference, so that i can use them exactly where they are required. I need the practical scenario not the theoretical definitions. If possible mail me [address removed]

Thanks in advance for your ideas.

Posted 18-Sep-12 4:24am

cm_Aryan

Updated 18-Sep-12 4:25am

Andrei Straut

v2

Add a Solution

Comments

[no name] 18-Sep-12 10:40am

What is wrong with reading how to use the function? http://www.ezineasp.net/post/ASP-Vbscript-DateAdd-function-with-Date-Intervals.aspx

cm_Aryan 18-Sep-12 11:14am

Hi Aday,

Thanks for you Comment. Actually i did that before itself.

My Problem is: both the parameters "w" and "d" when used with data function return the same output. What is the exact difference between the two parameters. Can you give an example where i can see the difference between them.

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Shaunak De · Accepted Answer · 2012-09-18T04:51:00

Solution 1

The documentation here tells the difference:
HERE

d - is day of the month
w - is day of the week

Now for your purpose / dateadd () function - the interval parameter only indicates what unit of time you are adding to your initial date [10 days, months, years etc]
So for this function: d, w, and even y will be identical, because they are only telling the function "add x days"

For other functions there is a difference between the two

Posted 18-Sep-12 4:51am

Shaunak De

Updated 18-Sep-12 4:52am

v2

Comments

cm_Aryan 18-Sep-12 11:13am

Thanks for that. Got clarity to some better extent.
As per your post w - is day of the week. Wqe know there are only 7 days a week. But when i specify 10 in place of w, i am getting the correct output, but as per the documentation reference given above It should be wrong because weekday must be between 1-7. Can you please clarify

Shaunak De 18-Sep-12 11:19am

You are a little confused on this. :)

Its very simple. Irrespective of w, d, or y, you are adding 10 "days". That is important in the adddate function. The interval is "day".

w will be used when you want to check if today is a monday or not, etc.

See the datepart method for use: http://msdn.microsoft.com/en-us/library/2dhha2f3.aspx

cm_Aryan 18-Sep-12 11:24am

Got it. Thanks Dude....

What is the difference between dateadd("d", 10, currentTime) dateadd("w", 10, currentTime)

1 solution

Solution 1

Add your solution here

Preview 0

What is the difference between dateadd("d", 10, currentTime) dateadd("w", 10, currentTime)

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us