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)
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?
I 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.
I have a ticketing application and I want to create a date based, sequential, ticket number.I'm leaning toward something based on Posix time as this generates a sufficiently large number and the likelihood of any two ticket numbers overlapping is slim to none (two people would have to just happen to hit the button at exactly the same time on two perfectly synchronized systems).Has anyone done anything like this or have any code snippets/ suggestions? At the moment, I'm just using a UNIX time converter someone posted elsewhere: [code] This works fine (although it's not POSIX time), but I wanted to see if anyone else had any feedback as well.
I 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
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?
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.
lets 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?
VB2008 - 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] .....
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?
How can we calculate week number in one month.I am bit confused about caliculating this week number in one month.for example if we take today date 8/12/2006.Now we are in which week ? 2nd or first week (in december month)Our zone is united kingdom..
I am trying to determine how to take a date and show what the week number is for that month. So 3/1/10 will be week 1, 3/16/10 will be week 3 and 3/30/10 will be week 5. I know how to get the week of the year number just not week of the month.
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
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.
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.
I 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.
I 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.
Would it be possible to search a table, confining to a specific date range based on a date-time column, and get a count of the 10 most used words in a particular var-char column excluding a list of words?All in SQL?Currently I am pulling out the records that match and sorting through the contents outside of SQL, I would think where I can do it directly on the server it would be more efficient.(SQL 2008)
