write a code that can calculate the difference between the datetime a article has been published and datetime of now.like this example :this article has been published 4 minutes ago...this article has been published about 2 days ago...
View 2 RepliesCan someone please help me make this work? I want to do in vb.net calculate time between to date like this:
startdate: 2011/12/30
enddate: 2011/12/31
Calculate: ? hour ? minute ? secends
I need to calculate the location of intersections between multiple date ranges, and the number of overlapping intersections. Then I need to show which date/time ranges overlap each of those intersecting sections. It is slightly more complicated than that so I'll do my best to explain by providing an example. I am working in VB.Net, but C# examples are acceptable as well as I work in both.
We have several high risk tasks that involve the same system. Below I have three example jobs named HR1/2/3/4 with start and end date/times.
HR1 {1/6/2010 10:00 - 1/6/2010 15:00}
HR2 {1/6/2010 11:00 - 1/6/2010 18:00}
HR3 {1/6/2010 12:00 - 1/6/2010 14:00}
[Code]....
I am trying to calculate the number of years for my calculate age event handler, however i am apparently missing a method or whatnot because im trying to calculate the age , can anyone suggest help on this. I need to subtract years to get my age but when i try the birthdate.Subtract (currentDate) method i get an error about not able to convert from LONG?
So below is what I have.
Private Sub btnCalculateAge_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnCalculateAge.Click
Dim currentDate As Date
Dim BirthDate As Date
Dim Age As Long
[CODE]
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?
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]...................
Title pretty much says it all. How do I format the date of a dateandtimepicker to insert it into the SQL date datatype?
View 20 Repliesthere, im doing a leave management system with vb 2005..and here's my problem -how do i 'find' the expiry date?? eg: from the datetimepicker in my form, if the date i select is 1st january 2009.....how do i type the code to find the expiry date 1 year later (which is 1st january 2010) and display the date in a textbox in my form???
View 1 RepliesI am trying to calculate the time difference between two points in time. I am using: Environment.TickCount.I set a long variable to the Environment.TickCount and then a second long variable to Environment.TickCount at a later point in time. I then subtract the second long variable from the first long variable, yet an incorrect difference is returned.
View 2 RepliesI have an ASP.NET application with a SQL Server back end. I am storing all my dates in UTC format and doing the appropriate conversions to the local time zone of the browser viewing it. One of the pages asks for a start date and end date (no times).
I am taking the start date and setting the time to 00:00:00 hours (midnight) and I'm taking the End time and adding a time of 23:59:59, so that the date range covers the whole day. Now what I'm trying to do is do a SQL query to do a search for records in this date range. The problem is, the data in SQL is in UTC time and the user is typing their dates and times in their local date and times. My quickest solution was to convert the date and time to UTC, then search the records. However, by doing this, I am to believe ASP.NET converts the given time and date to UTC based on the server time zone. How can I convert a date and time to UTC time based on the time zone of the user?
Is there a query that can use to sum up data from date until another date? how to do it in VB.NET.
View 1 RepliesI need to add 3 months to a date so i can calculate when a clients email bundle is out dated.so for instance the client registed his bundle on 2009/09/01. I need to be able to add 3 months to this date so it comes out with 2009/12/01 and then compare the dates.
View 1 Replieshow to calculate a weekday of a given date?
View 8 RepliesI have a two maskedtextbox, one textbox named as masktxtdepostdate and , masktxtmaturitydate, txtnoofmonth.
i changed maskedtextbox property as date, in format "YYYY-MM-DD";
now i need to calculate masktxtmaturitydate after entering the values in, masktxtdepostdate and txtnoofmonth.[code]...
I'd like do make a program which returns you how old you are, in years, months, weeks and days. But I didn't get it to compare different times. Input is a string which looks like 01.01.2011 (dd.mm.yyyy).
My code so far is this:
Try
dim date1 as string = '01.01.2011'
' Today
Dim date2 As Date
date2 = Date.Now
' number of seconds since date1
[Code] .....
I am attempting to import data in a batch from an Excel Worksheet to a Sql Server database. Everything works except for the one date field in the spreadsheet. The date returned is off by four years from the value in the spreadsheet. Example: The Excel sheet has a date 10/24/2010 14:18, but when I look at the column in my query, the date is 10/23/2006 2:18. This pattern, 4 years and 1 day earlier, is repeated for every row in the worksheet.
The Excel column comes to me as a custom type, formatted m/d/yyyy h:mm. I receive this from an outside vendor and having them change the column is not going to be my simplest solution.
For what it's worth, the relevent part of the query is:
Select [Date Created] From MyWorksheet
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 date time picker and i am selecting 1 date from calender.after selection of that date i want to refresh date time picker i.e. it should display todays date.
View 2 RepliesI 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 make a project car rentals but I have trouble counting time, to take the penalty when you return the car late,[code]but the results do not correspond..I want the result = 2 hours 10 minutes.
View 5 RepliesExample of a function that would return an integer (how many months old) based on a persons age when given the date of birth?
View 1 RepliesI need to calculate date difference using flowing query but it does not work. [code]...
View 3 RepliesIm a beginner at visual basic. I did some codes refering to a form in which I need to calculate the differences between my my date of birth to another date. I did a statement which gives me the difference between those in the format of years, but I need to know how I can put the months and days example if my birthdate is 11/26/1991 and I want to calculte how many years, month and days has transcurred until today it would be like 20 years 3 months and 11 days.
[Code]...
[Code]...
how could i make my datetimepicker to compute for the expiry date within 5 years... example date grated is 1/2/2012 and expires on 1/2/2016
I'm using
Days = Dat2.Subtract(Dat1).Days
where
Dat2 = today
Dat1 = installed date
to trace the days of a program installed in user's computer.However, the user can changes the system time of his computer to a advancing date. How can I get a SNTP time from internet to solve this problem?
I am using this line of code on form load event it is working very fine but i have to problems
1. It replaces the form name and display the date and time but i want to keep both date and time and forms caption separated by some space.
2. When form loads it load the current date and time but the time does not change it should run.
What should i do please please help me code is as follows
Me.Text = Date.Now.ToLongDateString & " - " & TimeOfDay
The problem that I'm having is that when I try to select a different date, the text doesn't go away. That may make no sence, but let me tell y'all what I've done.
1: Created a GroupBox
2: Put a DateTimePicker in the GroupBox
3: Put TextBoxs in the GroupBox
4: Changed the DateTimePicker to look like this:
A)Checked - False
B)Allow Drop - True
I thought that if I changed that, then the text in the text box would go to that specific date. It didn't do that, it just stays the same. What I'm trying to do is enter text in say 3/7/11 and when I choose date 6/12/12 it will display blank text boxes for me to enter something different.
How do i code a date time picker in form 1 and show the date and time in a label in another, I have 2 forms and a module to transfer.
View 4 RepliesHow to get the current date and time in textbox in IST ( Indian Standard Time) in vb.net ?
View 1 Repliesi'm using a date time picker with format set to time. i want to be able to trigger an event at the time selected in the date time picker
View 19 Replies