Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
max({$<Status={'Accepted'}>}date(YOURDATEFIELD,'DD/MM/YYYY'))-max({$<Status={'Pending'}>}date(YOURDATEFIELD,'DD/MM/YYYY'))
@G3S I like your solution. But why the date() function?
date(YOURDATEFIELD,'DD/MM/YYYY')
Why not just YOURDATEFIELD?
-Rob
@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.