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 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 textbox in my asp.net 3.5 VB.net webformin my textbox1 the text is : 30-Dec-2010, 06:00:00 PMi want when the date in textbox is greater than textbox1 then the Label text would be "No REfund
View 3 RepliesI have got the following code for if in textbox1 the would be appear as 10:10:00 AM and in textbox2 the time will appear as in 4 hours time slots automatically as 06:10:01 AM ..if the textbox2 time will be 06:10:01 AM then MSg box will appear that "You can not registered to this site because the 4 hours time slot will be over " [code]Remember in textbox1 the time would be any .....and textbox2 will auto generate time according to textbox1 to maintain 4 hours time slots between textbox1 and textbox2
View 1 Repliesi m using vb.net 2008.Example we have textbox1 and textbox2, question is how to show text from textbox1 into textbox2 but getting text line by line not all text from textbox1.
View 3 Repliesi want to display text from textbox1 & textbox2 into a label when click on button. the code is
label1.text = textbox1.text & " " & textbox2.text
i using the "" for spacing. is there any other way for doing spacing?
I have Tow TextBoxes . Textbox1.Text= "Hello" Is it possible to put this code TextBox1.Text in TextBox2 control Msgbo(TextBox2>Text)
View 12 RepliesThis should be pretty easy, I've been experimenting, just can't seem to figure it out. I'm trying to make a MsgBox popup with the text that is in Textbox1 and Textbox2. I want the MsgBox to display both values...
View 3 RepliesI'm running some if statement but I have hit a brick wall with what I'm doing and trying to do. If textbox1 has a value then I run different coding to if textbox1 and textbox2 have a value - Textbox1 will always have a value. [Code] What I'm trying to do is add an additional statement if both Textbox1 and Textbox2 have text, then to run code 1 if the last four characters in textbox2 ends in .jpg else to run code 2. [Code]
View 3 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 RepliesI've got a basic email application set up, and I'd like the "To" field (TextBox1) to be an autocomplete textbox.I'd also like the user to be able to edit what their contacts are, and so be able to add named to the autocomplete suggestions.I can get TextBox1's autocomplete suggestion to come from TextBox2's current Text - however this means I can only have one name as a suggested contact.Ideally, something like a list box would be ideal, so the user can add and remove names, and this list would then provide the source for the autocomplete.
View 14 Repliesmy sql statement is returning null when when I compare date from access database and date entered in textbox in vb. seems to me that the two dates are of different format so null is returned from the select statement but how do I go about this.[code]
View 3 RepliesLet's say that you have a texbox labeled TexBox2 and you don't want it to be seen when the program runs because TextBox1 pulls information from TextBox2 and it shows up inside of TextBox1. How would you go about doing this?
View 1 RepliesI am working on bit more advanced calculator, but I cant figure out how I can make my program to calculate textbox1.text and show the answer in textbox2
For example: (textbox1) 5*62+4
(textbox2)314
I'm not sure this question belong in this topic, but I don't know where else it should be?
I have 2 date ranges with 2 text box, based on that m populating reports.
I want to do in such a way if fromdate and todate <27/06/2009 then it should call come other SP otherwise diff one
[Code]....
How to compare DateTimePicker1 with DateTimePicker2?For example i wanted DateTimePicker1 must always be smaller than DateTimePicker2...
example
DateTimePicker1 > DateTimePicker2
'display message box error
i want to compare two data values in my database.These two dates belong to two different columns.What i want to compare is if the date of one column greater by 6 months from the date of other column then it should give error.I want to pass this query to database and check,and later on depending on the result want to insert my other functionality?
View 1 RepliesI have 2 Textboxes with Date/Time in them. I want to test if one is less than the other, here is my current code
Dim StartTime1TextBox As TextBox = TryCast(FormView1.FindControl("StartTime1TextBox"), TextBox)
Dim EndTime1TextBox As TextBox = TryCast(FormView1.FindControl("EndTime1TextBox"), TextBox)
If Not [String].IsNullOrEmpty(StartTime1TextBox.Text) Then
[code]....
However if I enter an Start time of 9:00 AM and an End Time of 5:00 PM this triggers the isvalid=false because 5 is less than 9. Doesn't look like it's comparing the date and time just number.
I am developing a billing application to help out the billing lady who has been doing our billing by hand. I am essentially done�. Except for one class of customer I can�t wrap my head around. Nuts and Bolts:
1.Data comes from a table that shows Storage id, customer id, Billing Start date, Billing end date.
2.I am kicking the data back out to a table and I�ll build her a nice little crystal she can run.
Problem:We rent storage space. If multiple customers use the same storage then they will split the cost of the daily fee. If there is 3 customers they each pay a third etc. This seems simple but If Customer 1 starts on 1/1/12 and ends 1/10/12 she pays 10 days. If Customer 2 comes in 1/3/12-1/9/12 they will split 7 days. If Customer 3 comes in only on 1/9/12 then they will all pay a third on that day. Now imagine this across 600+ storage units and 1000+ customers and each customer using multiple storage at any given time.
My biggest issue is I don�t know how to express how we do that calculation by hand programmatically. By hand process and how I figure I am eating the elephant: Find every Customer that has used the Space in the billing period -Determine the unique storage numbers that were used during the billing cycle kick the results to a storage table on an access database. I am using a table because I figured it would be less of burden for the application then a list or array.
Determine where there is overlap - Use �FOR� to cycle through the orginal data table using the unigue. Here is where I am stuck. How do I compare the dates in a way to determine which customer is using it when compared to the others. Obviously i can determine the difference in dates between the start and end. It is getting the applicaiton to recognize the dates are with in the other dates. here is kind of what I was thinking obviosly this doesn't work I am just using the format so don't crush me too bad because I code like a caveman.
Dim CustomerDifference as time span
Dim UniqueStorage as Integer
Dim Customer as string
[code]....
Compare With Todays Date? [code]....
View 1 RepliesMy collegeue and I have been searching on the net a hell of a lot for a problem he is facing and we so far have been unable to find a resolution.He has an Access Database where one of the columns is of Date format. This date is in UK style (as defined by the Operatins System)
In his application there is a datetime picker which the user picks from he then wants to select * from the access database where the dates match but because the DateTime Picker is giving a US Format date (i.e MM/dd/yyyy) and in the database its UK (i.e: dd/MM/yyyy) its not finding a match and returning no records.
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 have a table "Contracts", with fields CompanyNumber, MaturityDate and other fields.i have a form in vb.net, with a textbox that should check if the entered company number exist in my db, if it does it should check whether the maturity date is bigger or less than current date.Any one out there that knows how to go about it? Here is the code am trying with;
Private bindingSource1 As New BindingSource()
Private dataAdapter As New OleDbDataAdapter()
Dim connectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=mtc.mdb"
[code].....
be able to check if an application i am writing has been run on a week by week basis. i have created a button that when pressed creates a text file with nothing in it, i can read back the date it was created which also gives me the time which i dont need, i then need to compare the date the file was created to see if it is older than 6 days if so delete the file. how can i check to see if a creation date is older than six days???
View 9 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 RepliesMy application is in VS2008 coded in vb.net.I have a table with three columns FromDate,Todate and Schedule.FromDate and ToDate will have date values whereas Schedule will have a any of these values(weekly,Monthly,Yearly) In my Form i have given some provision to the user to check the records.
My requirement is The currentdate that is Today's date should be compared with the values of Fromdate and ToDate.First it should be check whether Schedule value is Weekly or Monthly or Yearly.If it is weekly than it should check the record in between fromDate to ToDate with a increment of one week.That means it should first check the first value of fromDate than add 7 days to the value and then again check from fromDate and this should continue till it reaches Todate.
[Code]...