Calculate Days

[#1]

Hi,

I have two calendar objects for start date and end date.

When i select dates in these objects, i want to calculate how many days and place it in a textbox.

How can I achieve this??

For ex :

Start   Date	End Date
01-Jul-14	06-Jul-14
Duration	5

Regards,

Shruthi

[VishalWaghole]

Hi Shruthi,

Try this

=GetFieldSelections(End Date)-GetFieldSelections(Start Date)

Hope it work for you.

-- Regards,

Vishal Waghole

[#3]

datee:

load * inline

[startdate, enddate

23-MAY-2014,28-MAY-2014

];

load date#(enddate,'D-MMM-YYYY' )   - date#(startdate,'D-MMM-YYYY') as ed Resident datee;

set

"=ed"

in Text object >properties > general tab > text

[MK_QSL]

Try

=Interval(Date(Date#([End Date],'DD-MMM-YYYY')) - Date(Date#([Start Date],'DD-MMM-YYYY')),'dd')

or

=Interval(Date(Date#(Max([End Date]),'DD-MMM-YYYY')) - Date(Date#(Max([Start Date]),'DD-MMM-YYYY')),'dd')

[DavidFoster1]

I think some detail got lost in translation there.

Could you provide some sample data (at least 2 rows) and the desired result?

[#6]

Try the interval key function to get those values inbetween the two dates