Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How can I find out the difference between two days?? Including the holidays.
Example:
(08/01/2011 08/05/2011) = 4 days
Hi,
If the field contains only date then you can try this.
Date1 - Date2.
Regards,
Kaushik Solanki
Date#('08/01/2011' - '08/05/2011')
forr two fields
Date#(DateField1-DateField1)
Actually I want to find out the total no of days from a particular Date to Today() date. It's needed for age analysis.
Date(Today())-Datefield
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.
Hi,
Try this.
Create a chart with P.Date as Dimension and expression as Today() - P.Date.
Regards,
Kaushik Solanki
Thank you Koushik, it's work fine. There is any way to solve this issue on script level???
Hi,
At script level you can try this.
Load
Today() - p.Date as Day_Difference
From xyz.
Regards,
Kaushik Solanki
Hi,
If you got the answer can you please mark this post as answered.
Regards,
Kaushik Solanki