Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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..
I don't get what you try to achieve in this?
Do you need number of days?
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...
To tell exactly it will be a number of days right?
Simply you can specify as (EndDate - StartDate)
i did the same thing but it shows year as 1900..
why would that show up then
Don't use date()
Use simply as Floor(EndDate-StartDate)
or
interval(EndDate-StartDate,'d')
Hope it helps
Hi
Try like this
=Num(EndDate) - Num(StartDate)
or
Interval()
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