I would like to get a 'due' or predicted inspection date based on alternating with another date? How would I go about this? [Code] The due inspection either can be 24 months (second yearly) but it has to alternate with the last safety inspection.
View 1 Replies
Say the user specifies these two dates....
Start Date: 2010-12-05
End Date: 2011-01-15
If I select December 2010 I should get the folllowing
startdate = 2010-12-05
enddate = 2010-12-31
Select January 2011 then
startdate = 2011-01-01
enddate = 2011-01-15
Should I subtract dates? How can I get the start and enddate for the current month/year based on the overall start and end date.I'm coding in vb.net.
I have two tables: a schedule table that contains information about how an employee is scheduled and a numbers table in which each number corresponds to a date.
[Code]...
I can do this on the SQL side or the code side. I have Linq at my disposal if I need it. The table doesn't need to be compiled by SQL. This will happen dynamically on a website and should be as efficient as possible.I don't want to have to iterate through each and look for breaks in contiguous days if I don't have to.
I am trying to get a list of dates from a provided StartDate and EndDate in my database, and use these dates to link to dates in a database (to display another variable on the y-axis of the chart) and to populate the x-axis of a chart (with the list of dates). Is it possible to get a list of dates in VB and pass them into a chart this way?
View 2 RepliesI need to get all dates between a start and end date and then add them to a list or collection.
View 2 RepliesHave a table called AProjects in a SQL Server Express 2008 Database. This table has a date field (Data Type date) called Due. Trying to extract a dataset based on the following code / query in the Form Load sub in VB 2008 Express: All variables have been declared
conn.ConnectionString = "Data Source=LaptopSQLEXPRESS;AttachDbFilename='C:Program FilesMicrosoft SQL ServerMSSQL10.SQLEXPRESSMSSQLDATABTISbe.mdf';Integrated Security=True;Connect Timeout=30;"
conn.Open()
sqlProjects = "SELECT AProjects.ProjID, AProjects.RefNo, Clients.Client, " & _
"Status.Status, AProjects.Due " & _
[Code]...
Before I build my own and after looking for quite a while (to no avai) does any one know of a function that will return the dates of a recurrence.
For instance:
- The recurrence might be the first Monday of each month.
- The second week of each month.
So what I want is to pass the recurrence information to the function and it will return in an array all the dates that are applicable.I've looked at some other topics here but none are as comprehensive as what I need.
Thought 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?
Would it be possible to search a table, confining to a specific date range based on a date-time column, and get a count of the 10 most used words in a particular var-char column excluding a list of words?All in SQL?Currently I am pulling out the records that match and sorting through the contents outside of SQL, I would think where I can do it directly on the server it would be more efficient.(SQL 2008)
View 4 RepliesI am using VB.NET. Is there a date function that calculates the date based on the number of months I have given?
for example, if i say July 2009 and looking for 10 months back, it should return Sept 2008.
I have an data base (.mdb) and it has a column with dates (dd/mm/yy) , some one give me a code to get all the dates in database between 2 dates , the code was :Select * from table where date between 'StartDate' and 'EndDate'but after I use the code , an error occurs told me that the types of data is not the same
[Code]...
I have a table which has the following Columns
TransDate(varchar20) , Name(varchar20), Address(varchar20), Amount(int), Balance(int)
Now i need to get "Recent Balance" which i am getting using the following Query Select Balance from myTable where TransDate = (Select Max(TransDate) from myTable) This query is giving me proper result if there is only one entry per day like below
10/12/2010 SomeName SomeAddress 1000 1000
10/13/2010 SomeName SomeAddress 1000 2000
10/14/2010 SomeName SomeAddress 1000 3000
But what if i have more than 1 entries per day as shown below?
10/12/2010 SomeName SomeAddress 1000 1000
10/12/2010 SomeName SomeAddress 1000 2000
10/12/2010 SomeName SomeAddress 1000 3000
How to get the "most recent balance" using the above date format?
I have a table which has the following ColumnsTransDate(varchar20) , Name(varchar20), Address(varchar20), Amount(int), Balance(int)Now i need to get "Recent Balance" which i am getting using the following QuerySelect Balance from myTable where TransDate = (Select Max(TransDate) from myTable)This query is giving me proper result if there is only one entry per day like below
View 7 Replieswhenever i have my date column sorted, and i add a date that needs to be sorted into the current dates, the datagrid does sort it properly, however, that last date in the datagrid always adopts the date of the newly added date. [code]
View 17 RepliesI am not sure how to accomplish this, but I am trying to take dates from two fields and using the current date show the progress percentage in a different field.
So, if past date is Jan 1st, the current date is "x", the future date is Jan 11th. How do I get a percentage of completion between Jan 1st and Jan 11th based on today's date Jan 5th?
BDate | EDate | % to completion
Jan 1st | Jan 11th | %
I 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 RepliesToday i am trying to convert a date i put in a textbox(txtJulian) to a normal date like 02/05/2011(or any other conversion depending what is imputed in the textbox). I cant get it to print to correct date. When I type 011-2011 it print out 1/11/2000when I want it to print 1/11/2011. Also the error messag doesnt show when I type nothing or the correct format in the txt box. Here is my code
View 10 RepliesI have a form where a user can choose an election date. One of the most frequent errors users make is entering the incorrect due dates of reports. Therefore, I am attempting to generate the report due dates in the application using the report guidelines. For instance, reports are due 32 and 15 days prior to the election and 30 and 60 days after an election.
I know the following won't work but you get the jest of what I am attempting to do. I am assuming I will need to break down the month, day and year somehow before I subtract or add the days to the date to get the actual report date.
[code]...
I have a dateTimePicker and I set the maxdate to today's date Now when a user select the date after today's date it won't select it but it still be displayed. How can I remove them or disable them do the users can't even click on the date if it is after today's date
View 7 RepliesI have a database (MDB, Access) and I connect it to my program using an OLE object,
now I have in the db a column filled with dates (ddmmyy),
I want to search and view (in Data grid view) all the fields that has a date before a Specific Date that I define .
the code of search that I used is :
SQLstr = "SELECT * FROM tb WHERE anomber = '" & TextBox1.Text & "'"
In VB2005 I am trying to calculate the number of business days between two dates. I must also account for U.S. holidays (New Year's Day, Martin Luther King Day, Memorial Day, Independence Day, Labor Day, Veterans Day, Thanksgiving Day/Friday after, Christmas Day). If a holiday falls on a Saturday, then the prior day (Friday) is assumed to be a holiday. Likewise, if the holiday falls on a Sunday then the following day (Monday) is assumed to be a holiday.
View 4 RepliesI am trying to flag rows in a grid in the following order based on a date column
When 2 or more days old from today
then RED
When 1 day old then YELLOW
When 0 days old then GREEN
When the date is in the future then
BLUE
I have the following which is working fine except for the future dates which are GREEN instead of BLUE.
Dim myDate As DateTime = CType(grdSummaryView.GetRowCellValue(e.RowHandle, "myDate"), DateTime)
Select Case Now.Subtract(myDate).Days
'2 or more days old then RED FLAG
Case Is >= 2
[code]....
I am teaching myself VB while creating a basic application I can use at work. Is there something in VB that will calculate a past and future date from a specific date. For instance, an Election Date falls on November 2, 2011. Once this election date is entered I want the program to calculate the reporting dates. The first report due is due exactly 32 days prior to the election. The 30 day post is due 30 days after the election.
View 2 RepliesIs it possible to disable the dates that appear before todays date in a dateTimePicker control?I want to put in some validation so that my users can only select days in the future...ie a future appointment date?
View 5 RepliesI need to figure out whether a certain date falls within a range of dates. For example the date 11/07/97 (MM/DD/YYYY) falls within the following range of dates formatted as shown below:
01-Apr and 31-May
01-Jun and 31-Oct
01-Nov and 31-Mar
how to manipulate the dates to determine which date will be 30 days more then the datetime control I have on my form. i need to take the chosen date from the DateTime control, and determine what date it will be in 30 days. Eventually I will use this process to search through the database to print monthly reports.
View 4 RepliesI am trying to make a reminder, but i can't figure out one thing. Anybody out there knows how? I would like my reminder to have a function when you select one date it automaticaly adds 2 reminders up to the day of the event. For example if you select the event at date 24 it would automatically add two events at the calendar at the dates 17 and 10.
View 3 RepliesI am have an issue with my between sql string. After testing this i have figured out the problem but don't know how to fix this. When i select two dates i want to get the records between(from two date time pickers) the sql string is taking the day as the month so if i: Input 7/10/2011 the sql between string reads it as 10/7/2011
This is my function :
Function ShowTableBetweenSetDates() As DataSet
Dim ds As New DataSet()
Try
[CODE]...
I 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 Replies
