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.
View 6 Replies
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 RepliesI 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 RepliesIn 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)
How 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 RepliesHow 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..
View 11 RepliesIs 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 am having a hard time finding some code to find a fiscal year. I want to be able to retrieve a Time stamp, and then find out what the Fiscal year is. July 1st thru the end of June So July 1,2011 thru Jun 31st, 2012 is all Fiscal Year "2012"
View 2 RepliesI 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]
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 have a code in vb
var weekOfYear=DateAndTime.DatePart(DateInterval.WeekOfYear, date, FirstDayOfWeek.Monday, FirstWeekOfYear.FirstFullWeek);
which is [URL].. I canÄ… find nothing equivalent to this in c¤, but I don't want to create new algorithm, which I think would have some bugs
i am looking for some tip to format a datetime stamp to format Saturday, December 31, 2011. I am able to get day of week, month, year in numbers but not in string. I can create arrays for days,month but i don't want to use lots of memory, if theres a function i can use it.
View 3 RepliesHow to get difference between two dates in Year/Month/Week/Day?
I have a problem with the difference between two dates. I need the out put in 0 YEAR, 0 MONTHS, 0 DAYS LEFTm e.g.:
1 YEAR, 2 MONTHS, 3 DAYS LEFT
With dateDiff function or using anything else it is not pos
I need to calculate the location of intersections between multiple date ranges, and the number of overlapping intersections. Then I need to show which date/time ranges overlap each of those intersecting sections. It is slightly more complicated than that so I'll do my best to explain by providing an example. I am working in VB.Net, but C# examples are acceptable as well as I work in both.
We have several high risk tasks that involve the same system. Below I have three example jobs named HR1/2/3/4 with start and end date/times.
HR1 {1/6/2010 10:00 - 1/6/2010 15:00}
HR2 {1/6/2010 11:00 - 1/6/2010 18:00}
HR3 {1/6/2010 12:00 - 1/6/2010 14:00}
[Code]....
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
View 5 RepliesHow 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
when i get system date and add some day or month or year then i want next date as per requirement.
View 1 RepliesI 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 RepliesI need to check my field in format ddMMyyyy(ex 12/03/1990) whether in interval of two dates that user picks from two date picker controls. Two date pickers are in custom format dd/MM. It does not matter for me if its between particular years. I need just to know if given Birthday belongs to interval taken from screen. Each datepicker gives values dd/mm/yyyy. I do not know how to check it. For example:Given date 12/03/1990 . User select two values from screen: From 01/01/1950 Upto 30/04/1949(or 1990, or 2000)
Result should be True.Because 12 march is between 01 Januar and 30 April.
I am useing Visual Basic 2008 and on a form....
....how do i display the week Number only in a textbox or label
is 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] .....
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 RepliesHow can i find the week number in a month.
A month can have 5 weeks, i need to know in which week i am.
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.
View 4 RepliesI 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
