So basically, I'm getting date information from the user and trying to convert it into a date format, and show it to the user in a text box which is obviously named "DisplayArrDate", and "DispArrDate" is a date variable and "MonthArr" & "DayArr" & "YearArr" are strings which are always numbers because they are selected from a drop down combo box.
Now, the code works perfectly on my computer and some others, but for some unknown reason, on some computers, even if they have the same local date settings, it gives me the error: "Conversion from string "4/13/2009" to type 'Date' is not valid.", that's just one example, where "13" is obviously the day. I use the month/day/year format because, in the toturial I'm reading, it tells me, that no matter my local date settings, when using VB 2008, the month/day/year format should always be used and it will display a date in the local format automatically. It seems that on some computers, this isn't the case, and the month/day format is creating errors.
Either I just can't seem to find the right way to word the problem or it's a lot more complicated than I thought, but what is the easiest way to assign the current date to a variable and format it to a specific format? Basically, I want to do the VB.net equivalent of this VBA line:
I'm try to come up with a way for a user to enter a date and time into a textbox and for that value to be saved as a datetime variable back into a database. I'm wondering if anyone knows of a clever way to restrict what values a the user can enter so that the datetime datatype isn't corrupted. I've been playing around with the date time picker but I cannot seem to get that to work for me. I'd like the user to either pick the date and time from a picker and save that into a variable. Or I've seen applications where the textbox will automatically have a formatting type of template that makes it hard for the user to enter an invalid date and time.
I am trying to format a date from a table that I'm getting so that I can concatenate it with another string.But I want the leading zero - I don't want 1/1/2009 - I want 01/01/2009.
I can't seem to find a formatting pattern that does this.
I have a datagridview in a form in windows application in which I have a column which accepts date values. In this column I want user to enter numeric values alone and when the user moves to next cell the value should get formatted to date type value(ex: 05/09/09). Similarly I have another column which must accept alphabets alone.
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
My user wants to have textbox fields that don't have any masks but wants those text fields to reformat any text that is entered as mm/dd if it is a real date entered
I am having difficulties with the VBE 2010 format statement. The mm gives only 00. The hh does not give 24 hour time. The nn does not show minutesMy code and the resulting output is shown belowThere also seems to be confusion between midnight and noonI start with 31 Dec 1979 10 pm and add hours getting31 Dec 1979 11 pmThen 1 Jan 1980 noonThen 1 Jan 1980 1 amWhat is happening here?
Public Const FolderOut As String = "E:/AgDocuments/" Public Const FileOut As String = "E:/AgDocuments/fOutput.txt" Dim fOut As New System.IO.StreamWriter(FileOut)
My user wants to have textbox fields that don't have any masks but wants those text fields to reformat any text that is entered as mm/dd if it is a real date entered. They won't be using the year.
I am in the process of automating a PowerPoint presentation that shows graphs that evaluate the Metrics of the organization. I have successfully created the graphs, with one exception. The dates I submit to be used in the X axis always changes format once it gets into the PPT presentation. The graph template that I clear and write over has the date format as "Jan-07". The new date data is now being written as "7-Jan". I tried submitting the data as a string, but no matter which way I formatted it ("January 2007, Jan 07, 07 Jan, etc") it would always change it to "7-Jan". Have any of you encountered this problem? Do you know how I can change the formats of dates in a PowerPoint MSGraph that is automated through VB.Net?
I am throwing some data out into Excel and am having some formatting troubles. I have 5 columns (date, time, a long number I don't want displayed in scientific notation - text is fine, text, text). I can get it all working with numberformat, however I have to do them different ways.
Date works this way cell.numberformat = "m/d/yy" and it formats it to say 3/1/11
Time works this way cell.numberformat = "h:mm AM/PM" and it formats it to say 8:07 AM
For the long number cell.numberformat = "@" and it doesn't change the format and it gets displayed in scientific notation
BUT if I use cell.style.numberformat = "@" it works as it should, but it messes up all of the date and time cells. Apparently when you use style.numberformat, it doesn't just apply to the cell you're working with. If I try using style.numberformat with the date and time formats, they don't change and are entered as if I didn't change the format at all.
I have some VB .NET software that interfaces to a load of old (but sound) COM objects. The VB provides a GUI for the COM objects, part of which consists of setting various options on the COM objects - several of which relate to string formatting.I have a simple pair of VB .NET functions that convert basic %f, %d, %g formats to/from .NET equivalents using a large select case covering specific common strings, but they don't cover all formats.[code]Before I start diving in and making it more versatile with some parsing, does anyone know of a class (eg VB or C# .NET) that provides a decent ready-made implementation? Or perhaps some regexp wizadry could be used?
if this is not the right area to be posting this. I couldn't find an area dedicated to discussion about IDE features.Somehow one of my .vb files is not showing the nice formatting that is default in VS2008, such as the text colors, etc. how I can get this back? I don't know what to search for, as I don't know what its actually called. On the left you see what I want, and on the right you see what I have right now.
I have a program that is calculating the cost of a certain number of plane tickets, the validation and basic calculations are fine the only problem i've got this: There is a discount text box field called "txtDiscount" where IF a user enters a number it will discount this as a percentage off the total cost of all the tickets, but I cannot get it to work [Code]
I have this string "0.9874" and I would like to use vb code to change it to "0.9.8.74" so that it looks like a proper version number.How do I do this? String.Format("{???}",MyString) or perhaps: