I made a little application that check the servers and if the servers go off for more than 5 mins then the program will sent me a mail.My problem is how do I compare the server date time witch display in a textbox to the real datetime which display in a label also how do I run the program constantly till the user decides to exit by clicking on a exit button.
View 4 Repliesi need to get date from database table and compare it either it today or tomoe..after that need to compare time.I got table where the format is 'datetime' contains like = 4/11/2010 12:00:00AM'....so i need to get the date only...how to do that?...when get the date ...ithen i need to compare a time.
View 1 RepliesIs there a way to compare two dates (which include time) ignoring the time? I have a 1/1/2009 8:00am and 1/1/2009 9:00am and I just want to know if it is the same day, without any care to what time it is. I know I can convert the date and compare the strings, but is there another way?
View 2 RepliesI want to compare just the date part (and Not the time) of two VB.NET Date objects.Is there a way to do that?
View 5 RepliesI want to compare my last transaction date / time which display in a label which I get from the data base to the system date / time and if there is a deference of 5 minutes then I get a massage.The code that I ve got check that the last transaction date is smaller but I dont know how to set it so that it only check for 5 minutes.This is what I ve got but its not doing what I expected.
Private Sub Command1_Click()
Dim date1 As Date
Dim label1 As Date[code]...........
I have an Sql server 2005 table called Emploeefl with 2 fields, EmployeeCode and Date of Birth. The data type for the date of birth is Datetime. I have a Date time picker on a vb.net 2005 form called dtDateOfbirth. When I click on the save button I get the error message "Conversion from string 'yyyy/MM/dd' is not valid. Below is the code
Dim newQE_Date As Date
newQE_Date = Format(Me.dtDateOfBirth.ToString, "yyyy/MM/dd")
'newQE_Date = String.Format("2008/09/10", "yyyy/MM/dd")
[Code]....
I have two textbox in my application.
Textbox1.Text="19-Jan-2010"
Textbox2.Text="Jan 2010"
May I know how can I compare that Textbox1 and Textbox2 text is within same month and same year?
I have a windows form where I want the time to constantly be updated. Right now it will take the current time from when the program was started.
For example, if I started the program at 4:30:29 PM that is what it will show the whole time the program runs.I need it to constantly be updated as the seconds tick by. So, If I started the program at 4:30:29 PM and ran it for exactly 5 minutes, the time displayed then should be 4:35:29 PM.The data being taken in and saved needs a time associated with it and the end user also need to know the current time as the program is ran in full-screen. [code]...
i want to format a datetime column like4-mar-10 9:15 pm
View 1 RepliesMe.List1_listdatetxt.DataBindings.Add("Text", Subject_Values.BindingSource4, "Listing Date")
How can I format this to m/dd/yyyy ? Currently it has 12:00 am , which i think is by default? because my csv datafile does not show the time
format( Me.List1_listdatetxt.DataBindings.Add("Text", Subject_Values.BindingSource4, "Listing Date"),#{0:M/dd/yyyy}#"
I have a datetime field in a SQL Server 2005 table that has values like this:
2012-04-23 09:00:00.000
2012-04-23 14:00:00.000
The minutes, seconds, and microseconds are always zero. I need to display a "time slot" (basically, the time plus one hour) like this:
2012/04/23 09:00 AM - 10:00 AM
2012/04/23 02:00 PM - 03:00 PM
I got what I needed using this:
[Code]...
I have a datetime field in a SQL Server 2005 table that has values like this:2012-04-23 09:00:00.0002012-04-23 14:00:00.000The minutes, seconds, and microseconds are always zero.I need to display a "time slot" (basically, the time plus one hour) like this:
2012/04/23 09:00 AM - 10:00 AM
2012/04/23 02:00 PM - 03:00 PM
[code].....
How can I best convert date and time string with format like:
"11/25/2009 6:30 AM" to "20091125_063000AM" ?
What is the syntax that should be used in order to check if 08-Jan-2010 is before or after today.
I mean:If 08-Jan-2011 < today's date Then
msgbox("08-Jan-2010 is in the past")
Elseif 08-Jan-2010 > today's date
msgbox("08-jan-2010 is in the future")
Else
msgbox("08-jan-2010 is today's date")
This is exactly what I need to know
I am coding ib Visual Basic. I need to store the current system time in MS Access timestamp field. How do I go about it.
Dim row As DataRow = ds.Tables("StudentTable").NewRow
row("SSMA_TimeStamp") = System.DateTime.Now.ToString()
how can i insert date day and time on status strip m using vb 2005
View 1 RepliesHow do I show a continuous time stamp on a label in windows form.
I am using vs.2005 - vb language
This is an annoying issue that started less than a week ago and couldn't come at a worse time, as I have a major project deadline to meet. At least once every TEN minutes, the program crashes with the error "Microsoft Visual Studio has stopped working" -- it only occurs when I am writing/editing code while execution is paused (Edit and Continue), which I do all the time since I am stepping through rather complex subroutines line-by-line. I literally have trained myself to save after each line of code I write, delete, or change, so thankfully I never lose much, if anything, when I restart, but it is irritating and time-consuming having to set up everything in the program and get to the place in the code that I was before. I have installed VS 2010 SP1, tried deleting the .suo file, and a few other supposed fixes that I came across online, to no avail.[code]...
View 5 RepliesI want to quickly limit the time that someone can use my program and do it without licensing software for now. Can I use an If'Then statement to check to see if today's date is later that a date that Ihard type similar to this conceptually. I am using VB2008.
If today's date > 1-1-10 then
Messagebox.Show ("Your trial period has expired.")
Else Form2.show()
Is it possible to create a program to run a program in another time?I mean you can run a program and give it a different time, such as three hours against the program (only by that program) say that one hour is?
View 12 RepliesI have been asked to create a program to create schedules for the Hospital where my wife works. Right now they do it in excel with a few macros. One question before I start, can multiple dates be selected from a DTP. Say for the month of July, my wife has to work the 3,4,5, the 10,11,12, the 17,18,19 and the 24,25,26. Can I select multiple dates for the month?
View 2 RepliesIs it just me or is it so that a DateTimePicker can only be used for entering dates or times but not both?
View 9 RepliesThought I'd see if Stack overflow is quicker than me testing something while I get a thousand interruptions from other work :)
I'm updating an old VB net application and trying to refactor some of the logic as I go. The app looks for data from a single date across a few tables and writes that view to a file.
Writing the query in SQL I'd get the equivalent of
SELECT * FROM table
WHERE CAST(FLOOR(CAST(table.date AS float))AS datetime) = '15-Jul-2010'
Ideally I'd use
SELECT * FROM table WHERE date=@input
and add a date object as a parameter to a System.Data.SqlClient.SqlCommand instance
Are those two comparable? Will I get the results I expect?
I am using VB 2008 and want to record a start date and time and then the stop date and time in a rich text box, i can get the start time into the box but so far can only stop the time instead of 2 seperate times, what i have is a drop down box with a list of computers 1-10 i was trying to get it so you picked a certain computer and that went into the text box then you started the timer and that was recorded, finally you stopped the timer and that was recorded but as i am a total newbie it does not work
Here is the code i have.
Public Class Form1
Dim time2 As Date
[CODE]...................
How do i declare date-time format in vb.net from sql server 2005? i dont know where to put this line
View 4 RepliesHow do i disable the dates that has already been passed. the user must not select the dates that has already been passed
View 2 RepliesHow can i make my app execute some code at specified day/time (Day/minutes/secconds)?I need to make a scheduled app that will backup(copy) some files at specified time/date.
View 4 RepliesI'm trying to compare the modify date of a file vs the current system date. I've found an MSDN article describing how to get the modify time of a file:
Dim infoReader As System.IO.FileInfo
infoReader = My.Computer.FileSystem.GetFileInfo("C: estfile.txt")
MsgBox("File was last modified on " & infoReader.LastWriteTime)
This gest the Date and Time, but I want just the Date not the time.
I need to compare the date that is entered with today's date minus some number of work days.
I used dateinterval.day, but that is the actual day, not the work day. i don't see a "simple" way to get work days.
For example, my number is 3, so i want 3 work days (M-F) not 3 days.
how can I create following thing with Visual basic?I would like my excel to check the date value in a cell and compare it to current date and if the value in the cell is older than 2 months compared to current date it would change the cell's colour.
View 1 Replies