DateAdd Function

[Mel]

When I use the DateAdd function using "DateInterval.W eekday" it does
not return the correct date, well at least how I thought the weekday
option should work. It is counting weekends and I only want it to
count the weekdays (Mon-Fri). How can I get it to work? (using
Asp.net 2.0, vb.net)

Example:
dPlanFD = DateAdd(DateInt erval.Weekday, 10, "11/04/2008")
'dPlanFD = #11/14/2008# 'I want it to return #11/18/2008#

[Mark Rae [MVP]]

"Mel" <ML********@gma il.comwrote in message
news:cc******** *************** ***********@f37 g2000pri.google groups.com...

When I use the DateAdd function using "DateInterval.W eekday" it does
not return the correct date, well at least how I thought the weekday
option should work.

A quick glance at the documentation will tell you what DateInterval.We ekday
actually means:
http://msdn.microsoft.com/en-us/libr...einterval.aspx

It is counting weekends and I only want it to count the weekdays
(Mon-Fri).
How can I get it to work? (using Asp.net 2.0, vb.net)

Write your own function, something like this:

Function WeekdayDiff(ByV al pdtmDate As DateTime, ByVal pintInterval As
Integer) As DateTime
Dim intDays As Integer = 1
Do Until intDays pintInterval
pdtmDate = pdtmDate.AddDay s(1)
If pdtmDate.DayOfW eek <DayOfWeek.Satu rday And pdtmDate.DayOfW eek
<DayOfWeek.Sund ay Then
intDays = intDays + 1
End If
Loop
Return pdtmDate
End Function

And call it like this: Dim dtmEnd As DateTime = WeekdayDiff(Dat eTime.Now,
10)

Also, do yourself a *HUGE* favour and forget about the Microsoft.Visua lBasic
"training wheels" namespace...
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

[Mel]

On Nov 4, 11:49*am, "Mark Rae [MVP]" <m...@markNOSPA Mrae.netwrote:

"Mel" <MLights...@gma il.comwrote in message

news:cc******** *************** ***********@f37 g2000pri.google groups.com...

When I use the DateAdd function using "DateInterval.W eekday" it does
not return the correct date, well at least how I thought the weekday
option should work.

A quick glance at the documentation will tell you what DateInterval.We ekday
actually means:http://msdn.microsoft.com/en-us/libr...lbasic.dateint...

It is counting weekends and I only want it to count the weekdays
(Mon-Fri).
How can I get it to work? (using Asp.net 2.0, vb.net)

Write your own function, something like this:

Function WeekdayDiff(ByV al pdtmDate As DateTime, ByVal pintInterval As
Integer) As DateTime
* * Dim intDays As Integer = 1
* * Do Until intDays pintInterval
* * * * pdtmDate = pdtmDate.AddDay s(1)
* * * * If pdtmDate.DayOfW eek <DayOfWeek.Satu rday And pdtmDate.DayOfW eek
<DayOfWeek.Sund ay Then
* * * * * * intDays = intDays + 1
* * * * End If
* * Loop
* * Return pdtmDate
End Function

And call it like this: Dim dtmEnd As DateTime = WeekdayDiff(Dat eTime.Now,
10)

Also, do yourself a *HUGE* favour and forget about the Microsoft.Visua lBasic
"training wheels" namespace...

--
Mark Rae
ASP.NET MVPhttp://www.markrae.net

That works. I adjusted it a little so it will subtract days too if
the interval is less than zero (I have some tasks that run from Finish
to Start). It works, very cool thank you. Too bad the DateAdd
function won't do it automatically but oh well.

:)

[Mark Rae [MVP]]

"Mel" <ML********@gma il.comwrote in message
news:0a******** *************** ***********@n33 g2000pri.google groups.com...

Too bad the DateAdd function won't do it

Rich as the .NET Framework is, it can't accommodate every single requirement
of every single developer in the whole world - there wouldn't be a hard disk
big enough to install it on...

Please do give serious consideration to doing without the
Microsoft.Visua lBasic namespace, though, especially if you're serious about
..NET development:
http://www.codeproject.com/KB/vb/novbruntimeref.aspx
http://www.knowdotnet.com/articles/f...namespace.html

And if you absolutely must use VB.NET, make sure you always have Option
Strict on...
--
Mark Rae
ASP.NET MVP
http://www.markrae.net