Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try below
=Interval(date(End,'DD/MM/YYYY')-date(Start,'DD/MM/YYYY'))
Regards
ASHFAQ
try left(date(End,'DD/MM/YYYY'),10)-left(date(Start,'DD/MM/YYYY'),10)
Hi Anushree_Shetty ,
Store both dates as variable .
And then make subtract ..You must get it
Thanks
Deepak
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
Hi Anushree,
Did you check my answer? Can you confirm if it's correct please.
Thanks,
Arun