.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Imran Ghani
Post New Web Links

How to calculate difference between two dates in years

Posted By:      Posted Date: October 06, 2010    Points: 0   Category :ASP.Net
 

hi all, 

i need to know if, given a birth date, a person has more than x years. Thats mean, the client must entry a date in a textbox and i need to know if the persona has more than 18 years. 


Thx in advance




View Complete Post


More Related Resource Links

Need function to find difference between two dates

  

Hi all


I need a function written in vb to find the exact month difference between two dates.


For example

    Start Date : 01/01/2010

    End Date   : 15/02/2010

 then the difference value should be like this 1.5  i.e i need the difference in decimal value.




how i can calculate date difference in oracle

  
how i can calculate the date diff in Oracle 10g using pl sql developer 7thank you

calculate business day between two dates

  
Hi Guys   I need the count of business days between two  dates Date1, Date2 i need the count only business day (exclude sartuday&sunday) If date1 is null or nothing i need to pass 0 If date2 is null or nothing i need to pass 0   help on this

How do i calculate no of days between two given dates

  
Dear All, My requirement is used to find no of days between two given dates and time(from date and to date). using c#. Thanx in advance Dinesh        

How can I calculate the Number of Weekends between two dates

  
I need to be able to figure out the number of Saturdays and the number of Sundays between two dates.  I know that I can do this by looping through the series of dates between the start date and end date.  Years ago I saw a piece of code that an ex-co worker wrote that accomplished this task using a formula.  The formula was extemely effecient.  Unfortunately I no longer have access to this code.  Does anyone have an algorithm that will perform this calculation that I can make use of?  Thanks

How do i calculate no of days between two dates n two times Using C#

  
Dear All, i got the task to find no of days between two dates n Two given times Using C# I have four fields( columns) Such as follows, Arrival Date, Arrival Time, Leaving Date and Leavingtime. Example: Leaving Date-24/08/2010,Leaving Time- 08:00 , Arrival Date- 12/09/2010 ,Arrival Time-16:00, From the above Example i need to find No of days. Note : Days should calculate from Leaving time to arrival time (with reference to above example it means if he starting at 8:00 o clock(24/08/2010)  in the morning the next day eight o clock will be one day(8:00/ 25/08/2010)) Thanx in advance    

How can I calculate the Number of days between two dates Monday to Friday

  

    I am using following code for Robert's Posted Code (Url:http://forums.asp.net/t/1142378.aspx) But this is for only calculate weekends saturday and sunday can any one tell me how 
I get Number of days between given two dates Monday to Friday.



private const int MONDAY = 1; private const int TUESDAY = 2; private const int WEDNESDAY = 3; private const int THURSDAY = 4; private const int FRIDAY = 5; private const int SATURDAY = 6; private const int SUNDAY = 7; /// <summary> /// Observe that the method calculates by including the start day, but excludes the end day /// </summary> /// <param name="startDate"></param> /// <param name="endDate"></param> /// <returns></returns> private void GetWeekendDaysBetween(DateTime startDate, DateTime endDate,out int saturdays,out int sundays) { saturdays = -1; sundays = -1; if (endDate < startDate) return; TimeSpan timeBetween = endDate.Subtract(startDate); int weekendsBetween = timeBetween.Days / 7; sundays =

Get Difference between two dates as Hours, Minutes

  

Hi,

 I am using the below query to get difference beiween two dates in hours and minutes.Minutes part look ok but the hours is incorrect.

 select datediff(minute,LastDate,getdate()) as "Minutes", datediff(hour,LastDate,getdate()) as "Hours"from emp.

 Note: Using SQL Server 2005


Regards
Janet


How to calculate working hours betwwen two dates?

  

Working days - Mon-Fri and Working hours - 9 Am to 5 Pm

Date1                                       Date2                                                Working Hours

Thur, 14-Oct-10 11.30 Am          Thur, 14-Oct-10 5.00 Am                     5.30

Fri,  15-Oct-10 11.30 Am            Mon, 18-Oct-10 5.00 Am                      13.30

Mon,  18-Oct-10 11.30 Am          Mon, 18-Oct-10 6.00 Am                      5.30

 


Thanks & Regards, PSWA

Get difference between 2 dates in minutes

  

I have 2 datetime columns:

Date1 = 10/1/2010 11:00:00 PM

Date2 = 10/2/2010 1:00:00 AM

I want to subtract Date 2 from Date1 and return the number of minutes difference.  Something like:

Date1 - Date2 = 120

How can I do this?

 

Thanks,

Bob


Months and Years between given two dates.

  

Hello All,

I have one query.

User will input two dates and I want to print months between those two dates.

 

  1. Suppose user enters From Date : 1-Apr-2010 and To Date : 15-Oct-2010

 

So my out put should be like

April

May

June

July

August

September

October

 

Please reply me sql query for that one as it is needed on urgent bases.



How to calculate total work hours between dates?

  
I am in the process of creating a calendar.  This calendar is to track leave hours for employees.  For example if a person takes leave for 2.5 days then the formula would calculate 8hrs per day and 4 hours for half a day = 20hrs.  I have part of the formula I believe "=TEXT([End Time]-[Start Time],"h")".  The problem is that it does not count multiple days and just not working right. Any advice would help.
Qjm

How to create a calculation in a list - Calculate the number of days between two dates

  

I have a calculated column in a list called Days Open. This column contains the number of days between today (Sysdate) and another column called the Effective Date. Therefore, if Sysdate is 11/16/2010 and the Effective Date is 10/14/2010, how do I calculate the number of days between the two dates?

I tried using this formula: =TEXT(Sysdate-[Effective Date],"h") and then I tried =INT(Sysdate-Effective Date) & TEXT(Sysdate-Effective Date, ":hh:mm")

Neither formula worked. I hope it is something real simple that I am missing here. Any help you can provide will be highly appreciated!


Calculate delta difference in the same table

  
Hello,

The following is the table creation and records insertion script

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[students] (
[studentid] [int] NULL,
[paymentdate] [date] NULL,
[pmtamt] [decimal](20, 2) NULL
) ON [PRIMARY]

GO

INSERT INTO [students] ([studentid] ,[paymentdate] ,[pmtamt])
VALUES
('1','2009-06-03','135.00'),
('2','2008-03-02','456.78'),
( '1','2008-06-03','654.00'),
('1', '2007-04-08','7895.00'),
('1','2010-06-03','427.00'),
('2','2009-07-08','3544.00'),
('3','2010-07-08','564.00'),
('3','2009-06-08','423.54'),
('3','2007-03-08','2342.00')

I need to find out the delta difference in payments between different years for each student.

I have been working on the following code

select A.studentid
, A.[year] , b.[year],
a.avgpmtamt,

What is the difference between "dynamic" and "object" keywords?

  
Let's take a quick look at the object keyword first. I'm not going to talk a lot about it because it's been around since C# 1.0. This keyword is nothing more than a shortcut for System.Object, which is the root type in the C# class hierarchy. (However, as Eric Lippert pointed out in his blog post, not everything in C# derives from object.) This is a powerful mechanism, since you can assign almost any value to instances of this type.

AGE CALCULATION IN YEARS AND MONTHS

  
How to calculate childs age,but when i enter childs age as '03/27/2007' it returns 3 years where as actual age is 2 yr 11 months

Calculate distance, bearing and more between Latitude/Longitude points

  
This page presents a variety of calculations for latitude/longitude points, with the formulæ and code fragments for implementing them.

All these formulæ are for calculations on the basis of a spherical earth (ignoring ellipsoidal effects) - which is accurate enough* for most purposes. [In fact, the earth is very slightly ellipsoidal; using a spherical model gives errors typically up to 0.3% - see notes for further details].
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend