Difference between two dates

[#1]

Hi,

I need to calculate the difference between two date for which I have been using the below expression

=round(date(End,'DD/MM/YYYY')-date(Start,'DD/MM/YYYY'))

where start is 21/07/2014 and end is 22/07/2014 and the expected result is 1

But, the value obtained is 0

So can anyone please let me know how this could be acheived.

[ashfaq_haseeb]

Try below

=Interval(date(End,'DD/MM/YYYY')-date(Start,'DD/MM/YYYY'))

Regards

ASHFAQ

[syukyo_zhu]

try left(date(End,'DD/MM/YYYY'),10)-left(date(Start,'DD/MM/YYYY'),10)

[sibideepak]

Hi Anushree_Shetty ,

Store both dates as variable .

And then make subtract ..You must get it

Thanks

Deepak

[#5]

Hi,

You can use following, get year, month, date from both the dates, then use num on them and get a difference.

for example, difference between 12/08/2014 and 01/01/2014 should be 223. Following code gives this result.

= num(makedate(2014, 08, 12)) - num(makedate(2014, 01, 01))

Thanks,

Arun

[SunilChauhan]

age(timestamp, date_of_birth)

Returns the age at the time of timestamp (in completed years) of somebody born on date_of_birth.

Examples:

age('2007-01-25', '2005-10-29') returns 1 

age('2007-10-29', '2005-10-29') returns 2 

age(end,start)

[#7]

Hi Anushree,

Did you check my answer? Can you confirm if it's correct please.

Thanks,

Arun