Difference Between Two Day's

[#1]

How can I find out the difference between two days?? Including the holidays.

Example:

(08/01/2011     08/05/2011) = 4 days

[kaushiknsolanki]

Hi,

    If the field contains only date then you can try this.

    Date1 - Date2.

Regards,

Kaushik Solanki 

[SunilChauhan]

Date#('08/01/2011'   -  '08/05/2011')

forr two fields

Date#(DateField1-DateField1)

[#4]

Actually I want to find out the total no of days from a particular Date to Today() date. It's needed for age analysis.

[SunilChauhan]

Date(Today())-Datefield

[#6]

Thank you Koushik and Sunil. Sunil I try your code but it's only show ' - '.

Actually I have a field P.date and I want to find out the difference between P.date and today(). That means whenever I run the application it's shown the difference between P.date and this particular date.

[kaushiknsolanki]

Hi,

    Try this.

     Create a chart with P.Date as Dimension and expression as Today() - P.Date.

Regards,

Kaushik Solanki   

[#8]

Thank you Koushik, it's work fine. There is any way to solve this issue on script level???

[kaushiknsolanki]

Hi,

   At script level you can try this.

   Load

   Today() - p.Date as Day_Difference

   From xyz.

Regards,

Kaushik Solanki

[kaushiknsolanki]

Hi,

   If you got the answer can you please mark this post as answered.

Regards,

Kaushik Solanki