summation of date

[shree909]

Hi i have a start date and end date

i want to do the substraction from end date to start date

my expression was

=date((start_date)-(end date),'MM_DD_YYYY')

when i do it shows  01/15/1900.

even i unchecked the force 0 on axis tab,

i also changed the fomat in the number as date.

can anyone had this type of issue..

[CELAMBARASAN]

I don't get what you try to achieve in this?

Do you need number of days?

[shree909]

i need date,month and year

i am trying to built a gantt chart , where i have a start date and end date..and a dimension..

so my first expression consits for  (start date - end date)

this range i want to show it as  bar and also the end date at the end of the bar...

[CELAMBARASAN]

To tell exactly it will be a number of days right?

Simply you can specify as (EndDate - StartDate)

[shree909]

i did the same thing but it shows year as 1900..

why would that show up then

[CELAMBARASAN]

Don't use date()

Use simply as Floor(EndDate-StartDate)

or

interval(EndDate-StartDate,'d')

Hope it helps

[MayilVahanan]

Hi

Try like this

=Num(EndDate) - Num(StartDate)

or

Interval()

[shree909]

thanks for  the reply but i want to show the end date on the bar.

for that i  caluculated on the show max value when i expanded the + sign but there it show   date as 1900

even i formated  like date((enddate),'MM-DD-YYYY').

is there a way it can be shown