How to calculate days in two values

[Subbu55]

 Hi All,

I have one requirement.

I have one date field is received date  and status field, in this status field two records 1. Pending 2. Accepted 

I want to calculate days in pending to accepted how many days taken.

Thanks in advance.

Regards,

Subba

[G3S]

max({$<Status={'Accepted'}>}date(YOURDATEFIELD,'DD/MM/YYYY'))-max({$<Status={'Pending'}>}date(YOURDATEFIELD,'DD/MM/YYYY'))

[rwunderlich]

@G3S I like your solution. But why the date() function?

date(YOURDATEFIELD,'DD/MM/YYYY')

Why not just YOURDATEFIELD?

-Rob

[G3S]

@rwunderlich Rob

if it is loaded as a date then no need for the function, but since I tried it as inline, I used the function.