Get The Difference Between 2 Date In Month And With Decimal Value For The Day Left

Jan 23, 2011

Is there a way to get the difference between two dates in Month. I would like decimal for the day.

EX :

First Date : 2010-12-20
Second Date : 2011-12-30

This is like 1 months and 10 days between these date.

The difference should give me : 1.33

DateTime dt = new DateTime();
dt = Convert.ToDateTime("2011-12-30"); ;
DateTime dt2 = new DateTime();
dt2 = Convert.ToDateTime("2010-12-20");
int monthDiff = System.Data.Linq.SqlClient.SqlMethods.DateDiffMonth(dt,dt2);

View 2 Replies

Similar Messages:

Web Forms :: Extract Month From Date Display Date Using Extracted Month?

Oct 11, 2013

How to extract Month from Date and then displaying the date using that extracted month??

I want to display dates according to Month. I have only "Date" column in database table.

I used below queries but it is not working:

string query= "SELECT EXTRACT(MONTH FROM date) AS Month FROM HolidayTable";
DataSet ds = new DataSet(query)
int month = Convert.ToInt32(ds.Tables[0].Rows[0][0]);
string query2 = "select date from HolidayTable where date= '" + month + "' ";

View 1 Replies

Web Forms :: Compare Two Dates (last Date Of The Month With First Date Of The Next Month)

Apr 30, 2010

comparing two dates Compare 2 days, last date of the month with first date of the next month!

example! 30-04-2010 with 01-05-2010 (or with datetime 30-04-2010 01:00:00 with 01-05-2010 01:00:00) If txt_remdate.Text < Now.Date Then

View 9 Replies

Crystal Reports :: Calculate Current Date(month) Minutes One Month?

Feb 25, 2011

How to calculate current date(month) minus one month in crystal report?

View 1 Replies

Web Forms :: Get Start And End Date In A Month Based On Month And Year

Jun 7, 2012

lblperiod.Text = " period " + "01/" + drpsmon.SelectedValue + "/" + drpsyr.SelectedItem.Text + "---" + System.DateTime.DaysInMonth(DateTime.Now.Year, DateTime.Now.Month) + "/" + drpsmon.SelectedValue + "/" + drpsyr.SelectedValue;

i want the daate ie the 1st to  the end of month when page is loaded i get the current months 01/06/2012 - 30/06/2012  but i want it on dropdown changed

i mean whever the user selcts in dropdown for month & year i want the period for the same

View 1 Replies

AJAX :: Show Only First Date And Last Date Of The Month In Calenderextender... Other Dates Will Be Visible False?

Jun 6, 2010

I have calenderextender in my 2.0 application, I need to show only first date and last date of the month in calenderextender... other dates will be visible false...

View 2 Replies

Web Forms :: How To Display Full Month Name With Date And Year In Date Format

Aug 5, 2013

I want to display the current month name,date and time like this "August 5, 2013 06:30:58 pm" using ajax. 

View 1 Replies

Web Forms :: DropDownLists - Populate Three Month Prior Date When Date Is Selected?

Mar 20, 2013

i need a requirement of date range should be of 3 months only i.e,the first month,year are selected automatically the second month should be of 3 months after the first month.


FROM month is jan is selected. To month should be march.

as that the data range selected in SBI where between 6 months.

View 1 Replies

Web Forms :: How To Get The Start Date And End Date Of A Month In Calendar

Jan 18, 2010

I need to get the start date and end date of a month so that I will pull up my records for only that month, Right now I am pulling all the records and taking lot of time to load.

Here is the code:


View 3 Replies

Difference Between Two Dates Expressed In Years As A Decimal

Feb 19, 2010

In VB how do you return the difference between two dates expressed in years as a decimal.

(DateDiff(DateInterval.Year, DateOne, DateTwo))

So that the result returns a decimal for example 15.76 years and not an integer

View 3 Replies

VS 2008 Difference Between Double And Decimal Data Types?

Nov 3, 2010

The biggest difference between double and decimal is that double is a floating point variable type whereas decimal is a fixed point variable .What it means?? Please Explain the abovePoint with Example.According to me both are used to store the folating numbers,then whats the difference between two?

View 1 Replies

C# - How To Find Year And Month Difference Between Two Dates

Jan 20, 2011

DateTime dayStart;
DateTime dateEnd;

TimeSpan ts = dateEnt - dateStart;

Print : ... Year(s) and ... Month(s)

how can I calculate it?.net framework 2.0c# project.

View 3 Replies

JQuery :: Get Difference Between Start Date And End Date?

Mar 17, 2011

i have two textboxes one is for start date and other for end date. if end date greater than start date then alert will raise? how i accomplish through with jquery?

View 3 Replies

Web Forms :: How To Get First Date Of Month

Aug 3, 2010

I am having FromDate and Todate boxes. By default by loading i need to set the fromDate as first date of current month even though the date may be 10 or 15, i should need to get the 1st date of the month. Then the toDate as current date of current month.

View 3 Replies

How To Set Due Date For Multiple Month

Jun 15, 2010

I have requirement that I want to set due date for payment collection for each month. e describe my requirement in brief.In my current application my client wants that He wants set starting and closing date for each month for payment collection . Now I have decide to have two text box for starting data and closing date.

View 4 Replies

How To Get Selected Month's Last Date In

Jan 20, 2011

I am using a drop down list for selecting the month in .aspx page. I have to get last date of the selected month in .aspx.cs page. (some months have 30 days and some have 31 days)

View 1 Replies

Convert Month Of Date To '01'?

Jan 26, 2010

I have the following statement:


The value Now.Month will return 1 for Jan, 2 for Feb, how can I convert to 01 and 02?

View 9 Replies

Databases :: Date Field Shows Up As Decimal, IBM AS400?

Feb 2, 2010

I am getting a DataTable from query against AS400 database. The field that clearly contains birth dates is interpreted as decimal. I am having trouble even converting it to string.

View 1 Replies

Web Forms :: How To Get Last Date Of Month In Label

Nov 22, 2010

I have one lable in that i want to get last date of month.. so how to display in label..

View 1 Replies

Web Forms :: How To Get Selected Month's Last Date

Jan 20, 2011

I am using a drop down list for selecting the month in .aspx page. I have to get last date of the selected month in .aspx.cs page. (some months have 30 days and some have 31 days)

How can I do this?

View 3 Replies

How To Add Date/month/year From Dropdownlist

Feb 11, 2011

I am developing a project in using c# coding. I m new to this field.

I need to add day/month/year to a text box in

I hv 3 drop-down list. when i m selecting 3 dropdown list, its value must de shown in a text box.

View 1 Replies

How To Subtract A Month From Date Object

Feb 3, 2010

How do I subtract a month from a date object in VB.NET?

I have tried:


However, given that Today is 01-Jan-2010, the result I get is 01-Dec-2010. The answer I want is 01-Dec-2009.

Is there a convenient way of doing this within the .NET framework?

View 4 Replies

SQL Server :: How To Get Both Month And Year Together From A Date

Jan 10, 2011

I have a column in report that should display month and year together i.e single column will have both month and year(this is the first column of the table).

Ex: JAN/11

How can I do this?

View 3 Replies

How To Detect Month According To Date Selected

Mar 21, 2011

I have two label in webform Label1 and Label2 Label1 displays the date as 1-Apr-2011

I want to display month as April in Label2 if date in label1 is in between 1 to 30 Apr 2011.

I want to display month as May in Label2 if date in label1 is in between 1 to 30 May 2011.

View 3 Replies

C# - Displaying Month-wise Date In GridView

Dec 21, 2010

I have an ASP.NET GridView in which i want to show dates from selected month and year. Month and year fields are DropDownList and bound to XML data source. Is there any easy to do that or i have to use Code behind to add dates using iteration.

View 1 Replies

Copyrights 2005-15, All rights reserved