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 RepliesI 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 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 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 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 RepliesGiven 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 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]
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 RepliesI 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]....
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 am useing Visual Basic 2008 and on a form....
....how do i display the week Number only in a textbox or label
How 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 RepliesUsing Visual Basic .NET, how can you find the number of Saturdays and Sundays of a specific year and month?
View 2 Replieshow to get the number of saturday and sunday of the specific year and month. I am using visual basic 2008
View 9 RepliesI am working on a program that will display the number of storms in a specified year. This program uses a text file with years 1990-2010 and the number of storms for each year.
txt file:
Year 2010
6
Year 2009
3
Year 2008
8
Year 2007
15
Year 2006
10 .....
A user selects a year from a ComboBox (cboYear) and the program displays the number of storms using a label object (lblNumberOfStroms) for that year. The user then can click a button (btnDisplayStatistics) and the program will display using a label object, the number of storms for that year. This seems like a simple application but I am having trouble grasping the use of arrays concept.
I am doing a bar cash register and I want to use a if statement to see if fosters button and number 1 on the number pad are both pressed then multiply constant by quantity number
View 1 RepliesI'm trying to calculate the total number of minute that pass 8.00am .. there are few record that the time are greater than 8.00 am which is : 08:15:00, 08:07:00, 08:05:14, 09:01:01 15 + 7 + 5 +61 =88 minute so I should get 88 minute then show it on label1.text
Dim dc As New DataClassesDataContext
Dim q = (From p In dc.times
Where p.name.Equals("Nick") And p.time > New TimeSpan(8, 0, 0) _
[code]....
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
how can i calculate number of days between two dates.....for xample between 24/12/2009
View 9 RepliesI have two date values.
Example:
Dim d1 As DateTime = New DateTime(2010, 6,6)
Dim d2 As DateTime = New DateTime(2011, 2,2)
How to code to calculate number of moths between two days? For example, BeginingDt=09/01/2007, EndingDt=05/20/2009 should be list as below:
2007:4
2008:12
2009:5
(If date of month >=15 will count as whole month, if <15 will be ignored)
I am trying to figure out how to calculate the number of years it takes to double a user defined number. I have tried to take the number entered and multiply it by twelev and divide by two.
View 2 Repliestrying to calculate the partitions for 8 portions, and putting in select statement for row number,something like,
If Not (dstotal.Tables(0).Rows(0)("totalrecord") = 0) Then
dPartition = CInt(dstotal.Tables(0).Rows(0)("totalrecord")) / 8
End If
[code]....
calculate the factorial of given number using recursion.input the number in textbox and show the
result in another textboxrajeev ranjan, on 29 March 2010 - 12:38 PM, said:calculate the factorial of
given number using recursion.input the number in textbox and show the result in another textbox.
I am hoping that someone can help me with a problem I've got at the moment using Compact Framework.Net 2 SP 2.At the moment I have a UI with a series of text boxes and each textbox displays the contents of a database field. These are shown one beneath another with a scroll bar on the right hand side of the form. Each textbox has a set width which might.I would like to adjust the height each text box based on the number of lines it is holding, the font size and the font in order to avoid using scroll bars on each textbox.[code]
View 3 Repliesi 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 am attempting to calculate the number of months between 2 dates in vb 2008. Effectively subtracting a date in the past from the current date and then manipulating it to the number of months between the two.
I have done this in VB 6 previously, but can't seem to do it in vb2008.
I am having trouble with the pennies calculator. I need to create an application which should calculate the number of dollars, quarters, dimes, nickels and pennies a person will receive when they cash in the pennies at a bank.Eveything seems to be working fine except the nickles...
Option Explicit On
Option Strict Off
Option Infer Off
Public Class frmMain
[code]....