Dim d1, d2 As DateTime
d1 = DateSerial(2009, 2, 29)
d2 = New DateTime(2009, 2, 29)
for some reason i thought the two statements would generate the same date, but they don't. i found this out when trying to do age(years / days) calculations. if you are born on a leap day, i.e. 2/29/2000, dateserial is useful in that in non-leap years it correctly identifies your birthday as 3/1.
I need to store a calculation to use later and obtain a new calculation
[Code]...
I have a date stored in my MS Access DB as "ShortDate" (dd/MM/yyyy).I need to read this date and compare it with "current date - X days". Where X days is a Value saved by the user (into another form 5, 30, 60 days... etc).In the short way: If "Current Date - 55 Days" it's equal OR in that interval of "DataBase Date" then MessageBox.Show("Warning!!! Expiring in {X} Days")
View 1 Repliesif the current hour is less than 21:00 (today) then show the remaining time in label3 as hh:mm:ss remaining. However, if the current hour is greater than 21:0
View 6 RepliesThis is a math calculation which is using factorial.
[Code]...
How do I add 2 text boxes together textbox one = $20 and textbox two = $40 and text box 3 adds both textboxes together to display = $60?
View 3 Repliesi have three text boxes that the user will input numerical data into to determine the area of an object. i need the result of my calculation to be displayed in a label but i cant figure it out.
View 2 RepliesI am trying to write the following application. A project has initial investment, yearly revenue and yearly expenses. The program should be able to take these data and calculate the break-even year, i.e. when the cumulative profits become 0. Also, it should have a listbox that would list the cumulative profit for 10 years. Refer to the example below. Now I know how to show it in the listbox but I am having trouble showing the break-even year. I know how to calculate it but how do you show it in years.
View 8 RepliesI have an application that has 3 list boxes, one selects a workshop, the other a location. the third is to display selected costs.to do the calculation a loop is required. i have written the code but when i calculate the cost the final result to be displayed ends up as being the cost of the last work shop and location * 3,What is supposed to happen is the location is multiplied by the number of days(3 in this case) and added to the workshop cost.the loop is supposed to add all cost from the list box till all have been added.what is happening is the calculation goes to the last entry as stated the multiplys this total by number of days(dbl)?
View 1 Replieshow to convert string to datetime and calculate date
View 3 RepliesI'm trying to match a certain DateTime value with the current system DateTime. I have a timer and a label on a form. Timer interval is set to 1000. When the form loads, the timer starts ticking. As soon as the current DateTime matches the value of the variable, it shows a message in the label. When I'm writing the following code, the values don't match even if the current system DateTime is equal to the variable. Label1 isn't showing 'Times Matched':[code]The default format of 'Now' is the same as I have stored in dtmVar variable. So there's no question of format mismatch. Does that mean 'Now' is not actually a DateTime property? Provided, my O.S. is Windows Vista Ultimate and all date/time settings are set to default.
View 1 RepliesI'm trying to match a certain DateTime value with the current system DateTime. I have a timer and a label on a form. Timer interval is set to 1000. When the form loads, the timer starts ticking. As soon as the current DateTime matches the value of the variable, it shows a message in the label.
When I'm writing the following code, the values don't match even if the current system DateTime is equal to the variable. Label1 isn't showing 'Times Matched':
Private Sub Timer1_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Timer1.Tick
Dim dtmNow As DateTime
[Code]....
Why is it so? The default format of 'Now' is the same as I have stored in dtmVar variable. So there's no question of format mismatch. Does that mean 'Now' is not actually a DateTime property? Provided, my O.S. is Windows Vista Ultimate and all date/time settings are set to default.
datetime1 and datetime2now two fields are have data ( date )in table recordi want to update only datetime2 is an emptyi am using visual basic 2010 ( visual studio 2010
View 1 RepliesI want to pick specific elements from DateTime and assign them to variables: Year, Month, Day, Hour, Minute, and Second. In MSDN, I saw ways to assign it all, but not what I needed.
Can anyone one give a hint, or two?
how can i set auto DATETIME...
View 5 RepliesI try to compare Datetime.Now with a Datetime variable I set, using the Datetime.CompareTo() method. I use a timer to compare these every second and display the result, but as the current time approaches the time I set, the result changes from 1 to -1, but never 0, which means these two are never equal. I'm suspecting the Datetime structure contains milliseconds?
View 7 RepliesAssume the following program is started at 1:59:01 AM on 3/13/2011 in the United States. The first time Timer1 ticks what will be the value of the TimeSpan (ts)?
Public Class Form1
Private Sub Timer1_Tick(sender As System.Object, _
e As System.EventArgs) Handles Timer1.Tick
[code].....
I'm trying to add the date and time of Today into a Sql-database-field that has the datetype datetime.
[Code]...
the msgbox gives me the following result: 29/01/2011 18:49:21 my sqlException gives me the following error: 102 - Incorrect syntax near '18'. Is it better that i set the datatype to char in my sql database? It's maybe a bit easier? When I do that, can I calculate with these date?
I am not new to vb but still an amateur, however, I am still learning linking vb apps to mysql, here is where my troubles begin. I am stuck and been trying for hours on end to get past this problem. It's starting to hurt my head! I am sure others have similar problems.I posted my imports and the module I put my public sub in. The sub is called as a form loads.The Error is:
An unhandled exception of type 'MySql.Data.Types.MySqlConversionException' occurred in MySql.Data.dll
Additional information: Unable to convert MySQL date/time value to System.DateTime
[code].....
It's been years since I've had to bother you with my silly questions but those had to do with VB 6. First of all, if I download the VS2010 Express edition will it replace all of my VS2008 edition, or will it be a separate entity. Also, the books I'm studying from are all 2008 -- will they still work on 2010?
[Code]...
I got the dates stored as varchar(100). I need to get them sorted when I use these records but I can't now because they are not stored as datetime. Is there any other way to sort dates or if somebody know would I loose my data if I would try to convert the column from varchar(100) to datetime now as it holds my dates or maybe it would convert ok?
View 33 Repliesmy form need to show the current date when click on button. the code inside the button is TextBox1.text = System.DateTime.Now.After clicking, the textbox show "9/29/2009 4:32:10 PM" may i know is it possible for me to show only the date and also to change the format to dd/mm/yyyy?
View 1 RepliesI would like to compare the month of a date with datetime.now, when the datetime.now reaches a month beyond the given date to play a sound. I am novice to this.
View 2 RepliesHere is the error that is getting thrown:
System.Data.SqlServerCe.SqlCeException was unhandled
HResult=-2147467259
Message="An overflow occurred while converting to datetime."
NativeError=25933
Source="SQL Server Compact ADO.NET Data Provider"
StackTrace:
[Code]...
I am importing a .txt file to a gatagridview and writing out a Schema.ini fileMy columns that contains a date value is empty in my DGV when i use the:DateTime in my .ini fileIf I set it to Char then my date is populatedDoes this mean my dates in the text file are not really dates but strings ??
View 2 RepliesI'm creating an XML file from values contained in a datatable. When I try to write an XML date value, I receive "String not recognized as a valid datetime. The dates that are stored in the datatable column is in this format "yyyymmdd". I tried to use XmlConvert.ToDateTime but I get a warning about the method being obsolete and I'm not sure what serialization mode I should use. How would I format the date from the datatable to MM/dd/yyyy and write to an XML file?
XmlWriter.WriteElementString("Add date", XmlConvert.ToDateTime(dr("Date_Added").ToString.Trim)))
I recently moved a webservice VB.net project from VS 2005 to VS 2008 and now a conversion I use to create a unique receipt number is no longer working.
The Format() function which is supposedly a Visual basic function gives the error:
'Format' is a type and cannot be used as an expression.
The Year() Function which is also a VB function gives the error:
Name 'Year' is not declared.
The Datetime() Function which is also a VB function gives the error:
'DateTime' is a type and cannot be used as an expression.
The actual code statement remains unchanged between the two web services but VS2005 compiles and VS2008 does not.
Dim julda As Long = CLng(Format(Year(oneRowDon.Item(8)), "0000") _
+ Format(DateTime("d", CDate("01/01/" _
+ Format(Year(oneRowDon.Item(8)), "0000")), oneRowDon.Item(8)) _
+ 1, "000"))
How can I achieve this. Insert Null Value into SQL Server DateTime Field?
View 5 RepliesI am having trouble with a mySQL query with the .NET connector. When I create the query, it automatically creates my parameters as objects. I usually change the type to the correct type, which in this case is Date, but I get different results passing in the parameter as a date.When I do "Preview Query" as an object, I get the correct results, but bad results as a Date. I would just leave them as objects, but it errors out when I try to pass a date in.Here's the part of my query that I'm having trouble with:
(Tickets.Resolved >= str_to_date(@startDate, '%m/%d/%Y')) AND (Tickets.Resolved <= str_to_date(@endDate, '%m/%d/%Y')) AND
(Tickets.Status = 'resolved' OR
Tickets.Status = 'rejected')
I have a datetimepicker and combobox on my form. If a user does not change the date on dtpicker or does not change text on combo box, these controls return null value, and the save operation fails. The controls are bound to data in a database.
View 1 Replies