PC Review


Reply
Thread Tools Rate Thread

how to calculate a date datacolumn based on other columns

 
 
=?Utf-8?B?QWhtZWQ=?=
Guest
Posts: n/a
 
      16th Sep 2004
Hi all,

I have two columns in my datetable the first is "StartDate", second is
"EndDate".

Now, I want to add a third column called "Days Count" that retrieves the
date difference in days between the the "StartDate" and "EndDate" columns..

I think it will be solved by using the expression property but the problem
is that expression property doesn't seem to work with dates.

any suggestions??
 
Reply With Quote
 
 
 
 
Miha Markic [MVP C#]
Guest
Posts: n/a
 
      16th Sep 2004
Hi Ahmed,

I suggest you to manually fill the calculated column.

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

"Ahmed" <(E-Mail Removed)> wrote in message
news:AADBB18D-2270-4D8D-9239-(E-Mail Removed)...
> Hi all,
>
> I have two columns in my datetable the first is "StartDate", second is
> "EndDate".
>
> Now, I want to add a third column called "Days Count" that retrieves the
> date difference in days between the the "StartDate" and "EndDate"
> columns..
>
> I think it will be solved by using the expression property but the problem
> is that expression property doesn't seem to work with dates.
>
> any suggestions??



 
Reply With Quote
 
=?Utf-8?B?QWhtZWQ=?=
Guest
Posts: n/a
 
      20th Sep 2004
thank you..

I did that.. I added two handlers for rowchanged and columnchanged events
and updated the "DaysCount" in these events. it works great till now.

BTW, how many MVP from Microsoft??

"Miha Markic [MVP C#]" wrote:

> Hi Ahmed,
>
> I suggest you to manually fill the calculated column.
>
> --
> Miha Markic [MVP C#] - RightHand .NET consulting & development
> miha at rthand com
> www.rthand.com
>
> "Ahmed" <(E-Mail Removed)> wrote in message
> news:AADBB18D-2270-4D8D-9239-(E-Mail Removed)...
> > Hi all,
> >
> > I have two columns in my datetable the first is "StartDate", second is
> > "EndDate".
> >
> > Now, I want to add a third column called "Days Count" that retrieves the
> > date difference in days between the the "StartDate" and "EndDate"
> > columns..
> >
> > I think it will be solved by using the expression property but the problem
> > is that expression property doesn't seem to work with dates.
> >
> > any suggestions??

>
>
>

 
Reply With Quote
 
Miha Markic [MVP C#]
Guest
Posts: n/a
 
      20th Sep 2004

"Ahmed" <(E-Mail Removed)> wrote in message
news:33DEC385-7981-4E5F-8759-(E-Mail Removed)...
> thank you..
>
> I did that.. I added two handlers for rowchanged and columnchanged events
> and updated the "DaysCount" in these events. it works great till now.
>
> BTW, how many MVP from Microsoft??


That many:
http://mvp.support.microsoft.com/def...ward&style=TOC

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: calculate a date based on specified day of the month Niek Otten Microsoft Excel Misc 1 17th Feb 2009 09:58 PM
Calculate Date based on Time Mayte Microsoft Excel Worksheet Functions 5 5th Jun 2008 06:20 PM
Calculate age based on birthdate & end date =?Utf-8?B?UmFjaGVsbGUgVy4=?= Microsoft Excel Misc 7 29th Jun 2007 03:58 PM
Calculate Monday date based on date typed in =?Utf-8?B?UGF0cmljaWE=?= Microsoft Access 2 20th Nov 2006 04:20 PM
Automatically calculate a date in a control based on another date. =?Utf-8?B?QkFSS0FST08=?= Microsoft Access Forms 3 4th Nov 2004 12:42 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:09 PM.