Getting values from DateTime

[John Slate]

I have a situation where users will input a start date and an end date,
then return the number of weekdays only. Is this possible with the
DateTime class?

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,

Use the calendar control in this way you dont have to worry about the
conversion, if you use something else like a textbox you should convert the
TextBox.Text to a DateTime before any date related operation
cheers,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"John Slate" <ph*******@yahoo.com> wrote in message
news:ek**************@tk2msftngp13.phx.gbl...

I have a situation where users will input a start date and an end date,
then return the number of weekdays only. Is this possible with the
DateTime class?

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[John Slate]

Yes, but what I wanted to know was whether there was a method or
property which would return the number of weekdays, excluding weekends,
from the selected dates...

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Bob Grommes]

The way you would find that out would be to review the properties and
methods of DateTime in the help file.

--Bob

"John Slate" <ph*******@yahoo.com> wrote in message
news:ua*************@TK2MSFTNGP15.phx.gbl...

Yes, but what I wanted to know was whether there was a method or
property which would return the number of weekdays, excluding weekends,
from the selected dates...

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[alan.washington]

DateTime dt_new;
DateTime dt_start, dt_end;
dt_start = Convert.ToDateTime("10/1/2004");
dt_end = Convert.ToDateTime("10/20/2004");

TimeSpan ts = dt_end - dt_start;
int numberOfDays = ts.Days;

for(int i = 0; i<numberOfDays; i++)
{
dt_new = dt_start.AddDays(i);
if(dt_new.DayOfWeek.ToString()!="Saturday"&&dt_new .DayOfWeek.ToString()!="Sunday")
{
listBox1.Items.Add(dt_new.ToString());
}
}

This will just look through every date between the two dates specified and see whether or not the date is saturday or sunday. If the date is, than it will not put that date in a listbox. I think this is what you are looking for.

I have a situation where users will input a start date and an end date,
then return the number of weekdays only. Is this possible with the
DateTime class

User submitted from AEWNET (http://www.aewnet.com/)

[John Slate]

there's one in every crowd

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[John Slate]

thanks!

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Chris Jobson]

It might be better to replace
if(dt_new.DayOfWeek.ToString()!="Saturday"&&dt_new .DayOfWeek.ToString()!="Sunday")
by
if(dt_new.DayOfWeek != DayOfWeek.Saturday && dt_new.DayOfWeek !=
DayOfWeek.Sunday)
because (a) it should be slightly faster, and (b) it doesn't rely on
locale-specific (if that's the right term) day names.

An even faster method could be to work out the number of complete weeks
(basically divide numberOfDays by 7) and multiply that by 5, then do some
adjustments for the partial weeks at the start and end of the date range -
but unless you're dealing with very long time spans it's probably not worth
the effort!

Chris Jobson

"alan.washington" <alan.washington@aew_nospam.com> wrote in message
news:uz**************@TK2MSFTNGP15.phx.gbl...

DateTime dt_new;
DateTime dt_start, dt_end;
dt_start = Convert.ToDateTime("10/1/2004");
dt_end = Convert.ToDateTime("10/20/2004");

TimeSpan ts = dt_end - dt_start;
int numberOfDays = ts.Days;

for(int i = 0; i<numberOfDays; i++)
{
dt_new = dt_start.AddDays(i);
if(dt_new.DayOfWeek.ToString()!="Saturday"&&dt_new .DayOfWeek.ToString()!="Sunday")
{
listBox1.Items.Add(dt_new.ToString());
}
}

This will just look through every date between the two dates specified and
see whether or not the date is saturday or sunday. If the date is, than
it will not put that date in a listbox. I think this is what you are
looking for.

I have a situation where users will input a start date and an end date,
then return the number of weekdays only. Is this possible with the
DateTime class?

User submitted from AEWNET (http://www.aewnet.com/)

[Liz]

Hey
Try this ... it worked for me.
<code>
public string DateAdder(string Date,double DayCount)
{
string [] strDate = Date.Split('/');
int Day = Convert.ToInt32(strDate[0]);
int Month = Convert.ToInt32(strDate[1]);
int Year = Convert.ToInt32(strDate[2]);
double one = 1;
double two = 2;
DateTime dt = new DateTime(Year,Month,Day);
DateTime NewDt = dt.AddDays(DayCount);
DateTime FinalDate;
switch(NewDt.DayOfWeek)
{
case DayOfWeek.Saturday:
FinalDate = NewDt.AddDays(two);
break;
case DayOfWeek.Sunday:
FinalDate = NewDt.AddDays(one);
break;
default:
FinalDate = NewDt;
break;
}
string ReturnDate = FinalDate.Day + "/" + FinalDate.Month + "/" +
FinalDate.Year;
return ReturnDate;
</code>

Cheers
Liz

"John Slate" wrote:

I have a situation where users will input a start date and an end date,
then return the number of weekdays only. Is this possible with the
DateTime class?

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!