I am working on a code where I need to add 21 years to the date 02/15/1957 and have it display the week day of that year. I have been looking at different web sites for visual basic
View 1 Replies
I need to find a way to find the date (DD/MM/YYYY) of the Monday for any week we're on.
For example, for this week, monday would be 09/11/2009, and if this were next week it'd be 16/11/2009.
I managed to get somewhere in the forms of code, but all I got was 'cannot convert to Integer' errors. I was using Date.Today and AddDays().
How to get difference between two dates in Year/Month/Week/Day?
How do i calculate exact difference between to date including years, days, moths, weeks. Just like windows calculator does. ?
And represent like this 1 years, 1 months, 1 week, 1 day
I need to generate a report that shows the 52 weeks of a year (or 53 weeks as some years have) and their start and end dates. There is an ISO spec to do this but seems awfully complicated! Im hoping someone knows of a way to do it in C# or Visual Basic (its actually for Visual Basic 6 but I will try port it across)
View 7 RepliesOk so i'm working on this project that requires me to imput a month and year which then will output the number of days in the selected month for you to select from, then determines what day of the week it is. The problem i'm having is that I cant get the month to the converted value that I need for it to work . Example: January will be the 13th month and february as the 14th of the previous year. Heres what i have so far if it helps. Aslo the code that I have to use to find the day of the week only works when the total is divided by 7, and then the value of the remainder is the day of the week with saturday =0, sunday=1, monday=2, and so on.
[code]...
A month consistof weeks and i want to find out which week of the current month.
View 2 RepliesI am writing a personal accountant software using VB2010. What I'm looking for now is to get the week date range of a specific date (Monday to Sunday). For example, if the given date is 16/03/2012, I want to get back:12/03/2012 -> 18/03/2012
View 5 RepliesI am now want to retrieve only year from my table(summary),field name(dates). So i am facing the problem on how to display the year in combo Box. my sql statement as below.
[code]...
I need a function that will give me the day of the week for any date...and possible assign the day of the week to a string...
View 1 RepliesI'm having some trouble getting the first day of the current week, then getting the date of that day.
Public NotInheritable Class FirstDayOfWeekUtility
Private Sub New()
End Sub
[Code]......
is there any ready to go solution within the microsoft framework, regarding conversion of date to day?For example, i would like to convert this string 21/03/2010 (dd/mm/yyyy) to Sunday?
View 5 RepliesSuppose $800 is deposited into a savings account earning 4% interest compounded annually, and $100 is added to the account at the end of each year. Calculate the amount of money in the account at the end of 10 years. Determine a formula for computing the balance at the end of one year based on the balance at the beginning of the year.Allow the user to input the beginning balance and the amount to be contributed at the end of each year. You must a loop in this program. [code] I cannot figure out how to make the previous years balance become the next years and so forth.
View 6 Repliesis there a simple builtin function that i could use to get a date instance from a calendarweek/year-combination?
It should be possible to enter 10w2005 into a TextBox and i'll create the date 07 March 2005 from it.
Monday should be first day and CalendarWeekRule should be FirstFullWeek.
My first approach was:
Dim w As Int32 = 10
Dim y As Int32 = 2005
Dim d As New Date(y, 1, 1)
[Code]....
I want to convert =now date value and i want to change that to the day of the week (eg. Friday). I need to do this to compare it with which day it is today.
View 1 Replieslets say i have a string that holds "Monday" and another string that holds "9:45:00 PM". would it be possible to look at the Date.Now() function and see when the next Monday is, and then convert those two strings into a date? lets say the next monday was 05/20/2011. I would want the date variable to hold "05/20/2011 9:45:00 PM". any ideas guys?
View 1 RepliesVB2008 - I need to display in 2 textboxes the first date in the week and the last date of the week when a user clicks any day within the calendar week using the MonthCalendar control. I have been messing with it and was able to return the integer values but not the date
Private Function GetLastDay(ByVal d As Date) As Date
Return d.AddDays(7 - d.DayOfWeek)
End Function
Private Sub MonthCalendar1_DateSelected(ByVal sender As Object, ByVal e As System.Windows.Forms.DateRangeEventArgs) Handles MonthCalendar1.DateSelected
[Code] .....
Given a week number, I need to get the date of the Monday of that week.For example, I have several strings that are stored in a file, such as
"WK 28 2010"
"WK 30 2010"
They could be any any valid week number.
The Monday on Week 28 of the year is 12 July 2010
The Monday on Week 30 of the year is 26 July 2010
Its these dates that I need.
I guess I could create a lookup table, but would prefer a more smarter approach so my software will be future compatible?
I am developing an ASPX VB.NET file. My assignment is to convert an integer representing week of the year into that end date. For example, if user selects Week 4 for 2011, I want to get date = 1/22/11. How do I do this in VB.NET?
View 2 RepliesI have two tables: a schedule table that contains information about how an employee is scheduled and a numbers table in which each number corresponds to a date.
[Code]...
I can do this on the SQL side or the code side. I have Linq at my disposal if I need it. The table doesn't need to be compiled by SQL. This will happen dynamically on a website and should be as efficient as possible.I don't want to have to iterate through each and look for breaks in contiguous days if I don't have to.
I have two datetimepicker controls now when I select February 22, 2010 from datetimepicker1 which is Monday I want the other datetimepicker2 to be February 25, 2010 which is Thursday. This means that I want datepicker2 to automatically look for the Thursday value of the week. I have set my week start day as Saturday and ends on Thursday, Friday is holiday.
Sample
Datetimpicker1 Datetimepicker2
02/20/2010 02/25/2010
02/21/2010 02/25/2010
02/25/2010 02/25/2010
Is it possible to calculate the currently selected date in a month calculator?I need to be able to produce a number between 1 and 5 for the currently selected week.
View 2 RepliesI need to find the date of Monday this week programmatically.For example, for this week Monday was on the 9th, so the date I need is: 09/11/2009.And when we roll over to next week it needs to calculate: 16/11/2009..I have tried doing this myself but I can't see how to do the arithmetic.
View 3 RepliesI m working on a site which requires me to calculate date(s) from the given week number for the year start set by the user in his setup.for ex. user set the year is from 1st April to 31st May in his setup and he selects week say 23rd then I have to find out dates for the week selected.
View 6 RepliesHow can I find the date of the Sunday of the first full week of a year using the DatePart function or something else? Jan 4 for 2009.
View 3 RepliesI am in a VB 2010 class right now, and I'm suppose to write a program that requests the user's date of birth and then display the day of the week (such as Sunday, Monday, ect...) on which day they will have or had their 21st. Birthday.
I already have the GUI made up with a MaskedTextBox set to simple date and it is named = mtbDayOfBirth
I also have the button already to calculate this, and a read only text box named = txtBox2.
My code so far is:
Private Sub Button2_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button2.Click
Dim d As Date = CDate(mtbDateOfBirth.Text)
txtBox2.Text =
End Sub
End Class
The only thing in my book only talks about how to pull the number of days from your bday or pull the full birthday as like the 04/06/1992 would return Monday, April 06, 1992.
I am trying to calculate the number of years for my calculate age event handler, however i am apparently missing a method or whatnot because im trying to calculate the age , can anyone suggest help on this. I need to subtract years to get my age but when i try the birthdate.Subtract (currentDate) method i get an error about not able to convert from LONG?
So below is what I have.
Private Sub btnCalculateAge_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnCalculateAge.Click
Dim currentDate As Date
Dim BirthDate As Date
Dim Age As Long
[CODE]
In regular SQL i could do something like
SELECT * From T GROUP BY DATEPART(wk, T.Date)
How can i do that in Linq to SQL ?
The following don't work
From F In DB.T Group R By DatePart(DateInterval.WeekOfYear, F.Date)
Also don't work:
From F In DB.T Group R By (F.Date.DayOfYear / 7)
I need my published vb 2008 application to open a helpfile that I wrote. It is a simple .txt-file and this piece of code does the trick as long as the program is not published because I already know where I placed the Helpfile:
System.Windows.Forms.Help.ShowHelp(Me, "C:Helpfile.txt", HelpNavigator.TableOfContents)
After it is published on another pc, the helpfile is not on the root of the c-drive but in the application folder of the program. However, I can not know where the path to the program folder of someone else's pc is. It all depends on where they decide to place the program when they install, right?
It seems I need to replace this little: "C:Helpfile.txt" with some code that searches all the drives and directories and/or points directly to the Helpfile's placement - i.e. the parent directory of the program.
I need my published vb 2008 application to open a helpfile that I wrote. It is a simple .txt-file and this piece of code does the trick as long as the program is not published because I already know where I placed the Helpfile:
System.Windows.Forms.Help.ShowHelp(Me, "C:Helpfile.txt", HelpNavigator.TableOfContents)
After it is published on another pc, the helpfile is not on the root of the c-drive but in the application folder of the program. However, I can not know where the path to the program folder of someone else's pc is. It all depends on where they decide to place the program when they install, right?
It seems I need to replace this little: "C:Helpfile.txt" with some code that searches all the drives and directories and/or points directly to the Helpfile's placement - i.e. the parent directory of the program.
I have following code (in VBA, excell) for calculating a date.I have variable for yeay, weeknumber and daynumber from week, now i wanna calculate the exact date. [code] But when i place this code in vb.net don't get the correct month.It displays correctly the year, day and daynumber but is displays the month as '00'. What do i have to change?
View 2 Replies
