I need a formula to find how many minutes have elapsed since a given date at 7:00 AM. So as of this posting it would be Now()-8/6/2009 07:00 AM.
View 3 RepliesI am using a stop watch to get the elapsed minutes and seconds which will then be displayed to user. How to I go about getting the elapsed time in the following format: 00:00
View 5 RepliesI have a date value (e.g. 2011-04-11 07:45:00.000) which I am pulling from my database (via Entity Framework). I need to pull out only the hour from the original date value (e.g. 07:45:00), get the current time, and then subtract the current time from the database time value. In pseudo-code, I'm looking to do something like this:
Dim my_date as DateTime = from_db ' This is the value pulled from the database.Dim this_date as DateTime = Date.Now ' This is pulled via a VB.NET function.Dim my_hour = my_date_but_only_hours ' Somehow, I need to strip the date off the my_date Dim this_hour = this_date_but_only_hours ' Same as line above.Dim hour_difference = my_hour - this_hour Response.Write("There are " & hour_difference & " hours left before the time runs out.")
So there's this accounting package at my client that spits out text-based reports with invalid dates, like February 31st or September 31st.The reports are formatted with spaces and mono-spaced fonts. The data that gets parsed out are fed into a more formal local SSRS report, and that's about all you need to know.
What I am interested in fixing is the situation where a date is invalid and can't be converted into a DateTime struct. The date format from the report is "MMM-dd-yy" (e.g. "Feb-30-10"). The date strings need to be fixed before being shown in the formal report. I've seen this done two ways in my time as a developer, and I want to come up with a cleverer way of doing it (if there isn't a built-in way I don't know about).The first bad method (I can't believe I'm even showing you!):
Dim month As Integer = <Parse out the month from the bad date string>
Dim day As Integer = <Parse out the day from the bad date string>
Dim year As Integer = <Parse out the year from the bad date string>
Dim validDate As DateTime
[code]....
I am looking for formula that is accurate in converting Minutes to Decimal Minutes i.e 30 minutes is 50 Minutes in Decimals so 1.3 hours is 1.50 and not 1.5 i have used Minutes/60 but it is not accurate as some times i have to Multiply the result by 100 and some time 1000 to get correct results based on single digit Try 1/60, 10/60 99/60 or 100/60.What would be the most efficient and correct way to Convert the time into Minutes ?
View 10 RepliesI want to place two radio buttons in so I can select one of them to use one formula, and then select the other to use another formula. I want to use the I=P(1+r)^n formula and I=P(1-r)^n formula with the radio button text showing Appreciation and Depreciation.
Heres my copy of the original code.
Public Class Form1
Private Sub cmdExit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdExit.Click
End
End Sub
[CODE].......................
I have an application that provides a countdown for 60 minutes and I'm currently using the win form timer and it updates some labels and a progressbar. Now I have to change this to be a countdown for 360 minutes. Will the win form timer be sufficient or should I implement a Timers.Timer instead?
View 6 RepliesI need the get a date object that specifies the next 2:00am that will come.
So pretend the time is 14:00 on the 15th, I need the date object to contain 2:00 on the 16th If the time is 1:00 on the 16th, I need the date object to contain 2:00 on the 16th
similiar question to the one asked before by someone, about age and date.
I have 2 fields in sql server 2008
DOB = "01/05/1952"
licence_age = 16
how do i get the year he go his licence from this information?
i have a problem in my project to find the Last Modified date of a site..
is any code to find that in asp.net
In my ASP.Net (VB Code) that I had 3 variable to store 3 different date.how can I compare 3 variable to find the last day between 3 date? [code]
View 3 RepliesI would like to find last date of previous month. How can I do that?
View 4 RepliesI am using this to loop through a directory and grab the last modified date for all of the files. How I do find the last or most recent modified date?
Sub Page_Load(ByVal sender As Object, ByVal er As EventArgs)
Dim info As DirectoryInfo = New DirectoryInfo("C:InetpubwwwrootG269_FocusUploads")
Dim files As FileInfo()
files = info.GetFiles("*.pdf")
[code]....
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
I'm creating a report in MS SQL Server Reporting Services and need to set the default Start and End Date report parameters to be the first and last dates of previous calendar month and need help.The report is generated on the 2nd calendar day of the month and I need values for:
Previous Calendar Month
- first day
- last day
I've been working with DateAdd, but have not been successful at creating an Expression (in VB.NET as I understand it).
I have a 500K+ lines vb.net app, written by 10+ different devs over the past 5 years. Many times it gets the system time and/or date and relies on it.Now I have to re-run real cases thru the program for regression testing purposes, and it screws up cases where the date/time matter. My fix is easy, just replace all the areas in the program that get current date/time with a sub that gets the current date/time, UNLESS I'm testing, in which case it will return the date/time of the original run. I have tried searching the sourcecode for the obvious 'current date/time' functions:
Now
DateAndTime.TimeOfDay
Date.ToDay
However, if I miss one, I LOSE.list more ways to get the current time, that might be hidden in the source code, that I can search for? Note: It's pretty clear none of the 3rd party libs in this system are returning date, well, one is, but I've caught it.
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.
View 3 RepliesI need to find the system date change made by the user, i can find out this by checking the event log, and the event log can be deleted so it is not good idea.Can anyone suggest a method to find out the system date change in windows?
View 3 Replieshow I could retrieve the date/time of the last Group Policy update. I have a crude routine that will search the Event Log for Event 1704, but this runs slower than I'd like. I was hoping there might be a way to get this info via Registry, WMI query, etc. that would work faster in my VB2010 program.
View 4 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 RepliesProtected Sub Calendar2_Selectionchanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles Calendar2.Selectionchanged
Dim myDate1 As String = ""
[Code].....
Have to find total days from two date controls after selecting dates in two controls it should print total days by calculating after immediate selection of second date control
example
textbox1.text has a value of 08:00
textbox2.text has a value of 16:00
[code].....
Is this the way to restart bw after timer has counted down?
Timer1.Interval = 30000 '30sec
Dim timercountdown As Double = Timer1.Interval / 1000
ToolStripStatusLabel2.Text = Nothing[code]....
I am trying to calculate a total cost from an elapsed time. Dependant on how long the time is, this will calculate the total cost. It has to be 3 to every hour. The elapsed time is displayed in label6 in "hh:MM:ss" format and the total cost needs to be displayed in label8.
View 4 RepliesI'm a starter in VB I just need to Know how to add elapsed event to timer in VB 2005 The timer has only Tick event
( if that not in vb 2005 what version of vb that supports the elapsed event )
I have VS 2008 and wow is it different from the old VB I used about 10 yrs ago! What I am trying to learn is how to create an ap that has a window that displays elapsed time like a stopwatch. Then I would like to be able to click a button to pause that time and start another timer, and then have yet another button to reset all. I have the form designed using a RichTextBox but am not sure that is the best way to display the times.
View 1 RepliesWhen I click a start button I want to start and display the time elapsed if HH:mm:ss. Best way to tackle this?
View 1 RepliesI have one text box that contains a value for the "Start Time" and another text box that contains a value for the "End Time."Both of the values are expressed in a format for military time (i.e. 1200, 1300, 1430, etc.).When the "End Time" text box loses focus, I would like the "Elasped Time" (expressed in minutes) to appear in a third text box.Seems easy enough...right?Well the problem I'm having is since the first two numbers in military time are base 24 and the last two numbers are base 60, a standard calculation subtracting the "End Time" from the "Start Time" does not yield an accurate result.
View 3 RepliesIm using the express edition of VB.Net to do my project. I have several threads in my program which run fine. However, im stuck at this problem. I have a button in my form, which if I click I will call ThreadA (works fine), If i keep it pressed for more than 2 sec i need to call ThreadB (doesnt work), and if the time is more than 2 min, i need to stop and send a msg to the user. I have tried the timer to calculate the elapsed time, so the tick function would call the thread. BUT this doesnt work... Im not sure what do to.
View 2 Repliesdisplay a Decimal (or double) to elapsed time [h]:mm:ss (hours:minutes:seconds)using vb.net?
example:
if you were to type "1.34666666666667" into a cell in Excel then choose Custom Format [h]:mm:ss The result is an elapsed time of "32:19:12". Using the OADate function only runs on a 24 hour clock so this does not work for longer durations unfortunately...