if the subtracted date is a saturday or sunday then subtract more days, before adding to arraylist..when i do this, the date stays the same and doesnt subtract, i get a conversion string to double error.[code]
View 2 RepliesI need to add a gridview to my page where the sqldatasource is based on a query that returns records that fall between Sunday and Saturday of the current week. (Each record has one date field) The records are for payroll purposes and the payroll week runs from Sunday to Saturday. I need to find all records that fall in the current pay week.
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 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 have a two buttons: Previous Week & Next Week When i run the app the LabelDate needs to shows up "May 31, 2010 - June 6, 2010" When i click a previous week button i want to set LabelDate's text to "May 24, 2010 - May 30, 2010" If i click Next Week button i want it shows up "June 7, 2010 - June 13, 2010" Means it should always display previous/next week starting from Monday and ending with Sunday.
View 4 RepliesHow can I get the first Sunday and Last Sunday of one month?
View 3 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 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 knoe every saturday of every month...i have the attendance date but when i calculate for report then i need to subtract the saturdays..so how can i knoe that there was how many saturdays in that month and how many saturdays ll be in next month and so on..
View 7 RepliesI think I have a function that'll throw up a messagebox if the current day is the Saturday before the Daylight Saving Time change for the US. The days it changes is the 2nd Sunday in March and the 1st Sunday in November, the time doesn't matter in this app, just the date.
Private Function CheckDST() As Boolean
With DateTime.Today
Select Case .Month 'Month is one based
[code].....
How can I get the date of first Sunday in a month?
For example in January, the first date of Sunday is 7. What code is needed to retrieve first Sunday date in a month?
how can I get the date of first Sunday in a month? For example in January, the first date of Sunday is 7.What code is needed to retrieve first Sunday date in a month?
View 9 RepliesThe problem that i have right now is that i don't really know how to compare two dates.What i am actually trying to do is to compare the Date Today with vbSunday, vbMonday etc using if. But something goes wrong. As for an example:
If Date.Today.Day = vbSunday Then
{
}
how to calculate how many Friday's or Sunday's are in given month in VB.Net ?
View 2 RepliesI need to count the sick leaves in a month, for that i have to ignor Sat-sun on a datetime picker. how to i set the DateTime picker to ignor Sat and Sun? Assume there are two date time pickers dt1 and dt2 thus there difference will return teh number of days without counting sat-sun.
View 3 Replieshow can I set color for column of Sunday in the current month of Date Time Picker Control?
View 2 RepliesHow do we add 15 days to the current Date which will not cross the month and resultant Date will never be Sunday? If it is Sunday make it Saturday?
Example > If Current Date is 17/08/2010 (DD/MM/YYYY)
Then Resultant Date is 31/08/2010 (DD/MM/YYYY) [Donot Cross the Current Month.]
Also 31/08/2010 would never be Sunday.
If it is Sunday make it 30/08/2010 (Saturday). [Date is not Sunday.]
Im writing a program to download a file from a official website every Sunday. The adress of this site keeps changing. Does anyone know how I can link to this address?
[URL]
I've highlighted the part of the adress that changes. As you can see, it's a date, but not nessesarily the current date. It could be yesterday, or the day before. I've tried something like this:
Dim link
link = "http:www.fiskeridir.no/content/download/4641/30774/version/254/file/Register-internett-*.xlsx"
This doesn't work.
I'm doing this program in Visual Basic and its supposed to calculate the GPA by entering the completed courses in a listbox. Its does calculate the GPA as its supposed to by adding the values using a "Add to list" button, but i have to also update the value of the GPA if a remove an item from the listbox using a "Remove from List" button. Is there a way a remove the line and also make the subtraction work.
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAddtoList.Click
'This is the Add button
course = txtCourseName.Text
[code]....
As part of a school assignment I have to design a program that allows people to add items to there backpacks but only upto a certain limit depending on age height etc. I completed the code to work out each packs maximum weight and thought I had almost finished but... Now I am trying to use a list box to add up the total weight of items added to each pack (below) but rather than add up I am just assigning the value 5 to the pack1weight.
Code:
Dim pack1weight As Integer
Dim tentW As Single
Dim maxweight1 As Single
[code]....
Im new to vb.net but learnt quiet abit, im using a book and getting to the stage where it gets confusing, anybody know of any videos or a better way to learn? first of all I have connected to a database but i want to beable to get the servername, username and password from a registry file instead of putting it directly into the code,
Also in the database I can add and update records etc... how would I make it take the current value in the table and add / subtract to it then update? eg. in the table i have 60, i want to add 10 to the value so 60 + 10 = 70 update record with 70. etc.
I would like to subtract a month using vb6.. Which function to use??
View 3 RepliesI wonder how I can subtract cells in VBA? I want to use an For-loop that subtract column "B" with column "C". I want it to take all the values in kolumn "B" minus ( - ) all values in column "C" in the whole range.
View 12 RepliesI'm stuck on writing a query to subtract "Amount to pay" with "amount paid", my assignment sheet says to 'use two queries and subtract in vb'. but i still don't really understand it
What the program is supposed to do is:
1. the user types in a specific customer id
2. the button "What is owed by the Customer ID?" runs the query
3. the query returns and opens a HTML with the customer id, the amount to pay, the amount paid and the total amount.so far what i've come up with is:
sSql = "SELECT CustID, SUM(AmountToPay) As AmountOwing, SUM(AmountPaid) As PaidOff FROM Order, Payment WHERE Order.CustID = Payment.CustID AND CustID = " & sSearchValueA & "GROUP BY CustID;"
I have 15 ofTextBoxs.1 to 5 is TextBoxs have a fix value and 6 to 10 is TextBoxs where the user
can input some value ,finally the textboxs 11 to 15 as a result What i want to do is when user input the value in textboxes(6) then the result automatically raise in textboxes(11).Then when put value in textboxes(7) then result automatically in textboxes(12) and also..
[Code]...
I'm looking to design a calculator that adds and subtracts binary numbers. I'm new to this program and stumbling on where to start?
View 6 RepliesCan someone show me an example of how to add or subtract when you have the button value going into the textbox like this[code]...
View 4 RepliesI have built a small VB.NET Calculator but whenever I add, subtract or multiply by 0 the answer is always 0. Here is my code:
Spoiler
Option Explicit On
Public Class Calculator2
[Code]....
In excel macro i got this two variables:
TimeF_1h = Cells(x, 3) - 0.041667
TimeF_12h = Cells(x, 3) - 0.5
i tried to do the same in Vb.net, but something is wrong i assume i should do it other way.
TimeF_1h = .Cells(x, 3).Value - 0.041667
TimeF_12h = .Cells(x, 3).Value - 0.5
I don't know what does it mean:
0.041667 and 0.5
in excel column are dates in this format:
2011-03-07 16:35:23
can i do this in VB.NEt example i wanna subtract the difference from 8:00 AM TO 12:00 pm how can i do this what namespace do i need? how can i add time? how can i add two dates
View 3 Replies