By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,558 Members | 1,373 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,558 IT Pros & Developers. It's quick & easy.

Find every saturday and sunday in an interval of two dates

P: 3
Hello. I've been working on a program for several days and I already have a few thousands of lines of codes written. But I'm facing with a big dilemma right now.

I'm kind of new to .NET, I'm working in Visual Studio 2013. I'm trying to find an easiest way to do the following:

I've got these objects:


In the DateTimePicker1, the user chooses the starting date. Let's say 1. january 2014.
In the DateTimePicker2, the user chooses the ending date. Let's say 1. july 2014.

Now, what I need the program to do is that when the user clicks on Button1, the following will show up in Label1 and Label2:

Label1 will show total days in a number in between the dates chosen in DateTimePicker 1 and 2.
label2 will show total days in a number in between the dates chosen in DateTimePicker 1 and 2 WITHOUT every sunday and saturday that occurs in between these two dates.

Also, every saturday's and sunday's dates in between the dates chosen in DateTimePicker 1 and 2 will be added to the ListBox1.

Is there anyone who could help me out? It's an important project to me and I still have about 40% of coding left, but this is stopping me. I can't continue working on my program until I get this solved. Thank you very much.
Jan 21 '14 #1
Share this Question
Share on Google+
4 Replies

Expert Mod 10K+
P: 12,359
What have you tried so far and what errors are you getting?
Jan 21 '14 #2

P: 3
Well I was trying lots of things. I know the code to count all of the days in between that interval:
Expand|Select|Wrap|Line Numbers
  1. Dim date1 As Date
  2. Dim date2 As Date
  4. date1 = Convert.ToDateTime(DateTimePicker1.Value)
  5. date2 = Convert.ToDateTime(DateTimePicker2.Value)
  6. Dim diff As System.TimeSpan = date2 - date1
  7. Label1.Text = diff.Days + 1
And I was trying to use While, For and so on to somehow get all the dates of weekdays to be written in the ListBox1, but I can't figure out a proper way.

I found some code to count all of the fridays in a specified date range, but it didn't fit my case. Also, I couldn't get the dates to be written in ListBox1 as separate items. And due to it's format being DateTime, not Date even after I wrote Date only, it was writing the items as e.g. 25.4.2014; 17:32... but I don't want the time to be there. I believe it's due to the DateTimePicker's DateTime only format being available.
Jan 21 '14 #3

Expert Mod 10K+
P: 12,359
Please show me the loop you tried.
Jan 21 '14 #4

P: 3
I've got my question already answered. Thank you anyways :)
Jan 21 '14 #5

Post your reply

Sign in to post your reply or Sign up for a free account.