Welcome :Guest
Congratulations!!!

Top 5 Contributors of the Month
david stephan
yasminpriya
Gaurav Pal
Ram
christianasteves

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 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 = ```

Calculating yrs, months, days, hours, mins, seconds between two dates. SQL

I'm trying to calculate the yrs, months, days, hours, mins, seconds between two dates with sql server or c# (ive just used sql more).

I have some code below that I started, but I get some negative values for months, values over 31 for months, and there very well could be more issues. Honestly my math is not the greatest and Im just not sure how to fix it. I want the user to be able to enter their birthday and for it to calculate the yrs, months, days, hours, mins, and seconds they have been alive.

Any help would be great

Thanks

```SELECT DATEDIFF(YEAR,'10/16/1995',GETDATE()) AS Years,
((DATEDIFF(MONTH,'10/16/1995',GETDATE()))-(DATEDIFF(YEAR,'10/16/1995',GETDATE())*12)) AS 'Months',
(DATEDIFF(DAY,'10/16/1995',GETDATE()))-(DATEDIFF(MONTH,'10/16/1995',GETDATE())*30) AS 'Days',
(DATEDIFF(HOUR,'10/16/1995',GETDATE()))-(DATEDIFF(DAY,'10/16/1995',GETDATE())*24) AS 'Hours',
(DATEDIFF(MINUTE,'10/16/1995',GETDATE()))-(DATEDIFF(HOUR,'10/16/1995',GETDATE())*60) AS 'Minutes',
(DATEDIFF(SECOND,'10/16/1995',GETDATE()))-(DATEDIFF(MINUTE,'10/16/1995',GETDATE())*60) AS 'Seconds'
;```

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!

Editor's Note: The Future: A Few Days Away

The past year has been full of uncertainty and change. A year ago, everything seemed to be falling into place. Windows XP was nearing final release. An RC version of the Microsoft . NET Framework was whetting our appetites for the final February release.

MSDN Magazine November 2002

Only 12 days left in the Code Contest!

We are having a fun coding contest to find the best solution to a fairly trivial coding problem.  Come along and show off your skills . you might just win a totally awesome Gyroscope Powerball!

Participate in the Code Contest!

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.

Force password expiration after x days

Using C# and sqlmembershipprovider forms authentication, is there a way to force user password to expire and need to be reset after x number of days?

So if a user launches the website login.aspx page, when they type their userid, it will check if the password is expired and direct them to a Resetpassword.aspx page?

Sharepoint access dissabled automatically in every two days

The problem seems to be that our administrators grant access to specific portals / folders and then without warning or any actions from our part the next week access is disabled

Display 'Top Queries Over Previous 30 Days' to users

In the Site Usage Reports, there is a section for 'Top Queries Over Previous 30 Days'. I would like to display this information to users.

Is there a existing webpart for this?
Is the data stored in a list that can be used for this purpose?

Thanks,

Steve Clark
Twin-Soft.com

How to add days in date using javascript

Hi following is the javascript code which i used for adding days to date

my date is 25/08/2010  and i want to add 8 days to this date  the answer should be 03/09/2010. how it is possible. i tried following code but showing error.

Regards

K L BAIJU

```<script type="text/javascript" language="javascript">

function check()
{
var myDate = new Date();
myDate.setDate(myDate.getDate()+8);
var vFormat="MM/dd/yyyy";
var vYear             = (vFormat.indexOf("yyyy")>-1?vYearLong:vYearShort)
var myDateString       = vFormat.replace(/dd/g, vDay).replace(/MM/g, vMonth).replace(/y{1,4}/g, vYear)
myDateString           = myDateString.replace(/hh/g, vHour).replace(/mm/g, vMinute).replace(/ss/g, vSecond)
}

return ((vNumber < 10) ? "0" : "") + vNumber
}

</scri```

Absence and vacation days webparts calculation

hi,

does any1 know if there is a webpart that can calculate an employee's vacation days. and when the employee request some vacation days it show the days that are left.

or is there a tutorial to create such a webpart?

thnx

How to increment default dates in the subscription

I have a report that I want run on a monthly subscription, but the report has a default date parameter. Is there a way to have the default date parameter increment each month. So if I choose to receive the subscription monthly I would want that default date to increment.

month days in gridview

Hello all,

I have a challenge of which I can't figure out how to achieve it.

at this moment I have a gridview that can be dynamicly filled with cell's based upon the number of items selected (throug a drop down list) by a user.

the user then can enter some values in the cells to perform a bulk insert.

What I rather want is that the user selects a month, like august, and then  the gridview is filled with the amount of days from that month, so you get 31 cells in the gridview. second all the first cells should be filled with the daynumber for that day...

I hope the explanation is clear :)

Does anyone know a solution to this?

Thanks,

Peter

Get Dates from Sunday thru Saturday

I'm using the date picker and I need to know how (or if it's even possible), to select a date, and based on the date, have the actual query use the week the date was in and return all the records from that week (Sunday through Saturday)

Like - if I pick 8/24/2010 - it returns a date range of 8/22 through 8/28
I'd also like to display the date range in the report, somehow

Any ideas on how I do this?

select records within 30 days of previous records

I have a table with a list of patient id's and there begin date and end dates as follows: ID     begin_date  end_date 1234 10/09/2009 10/16/2009 1234 12/16/2009 12/22/2009 1234 12/28/2009 12/30/2009 1234 01/13/2010 01/19/2010 1234 04/29/2010 05/05/2010 what i need to do is select the records that have an end_date within 30 days of a begin_date. So in the above example, i would need to get the following records: ID     begin_date   end_date 1234 12/28/2009   12/30/2009 1234 01/13/2010   01/19/2010 Because 12/28/2009 is 30 days within 12/22/2009 (previous end_date) and 01/13/2010 is within 30 days of 12/30/2009 (previous end_date) and 12/22/2009 (2nd previous end_date). is there a good way to do this using T-SQL?
 Categories:
 ASP.Net Windows Application .NET Framework C# VB.Net ADO.Net Sql Server SharePoint Silverlight Others All