cal date difference

[unknownly]

Hi,
I have bill status field and date&time stamp field. I have to find the #of days in status(from old status to new status)for a bill how do I do this

Thank you in advance,
Sweetie

 

[synapsevampire]

Examples would have helped.

If you have more than one status row per entity, then it sounds like you should group by the client, and then order by the datetime field, then in the details place a formula which states:

if previous({table.client}) = {table.client} then
totext({table.datetime} - previous({table.datetime}),0,"")
else
"N/A"

-k

 

[unknownly]

Sorry for not put up example

BIll id date/time old status new status

001 07/06/05 10:30 new
001 07/06/05 10:40 new pend
001 07/08/05 11:40 pend pend
001 08/02/05 01:30 pend paid

I need to cal the days between the status cahnge

Thank you

 

[synapsevampire]

OK, make slight mod:

If previous({table.billid}) = {table.bill}
and
{table.status} <> "new" then
totext({table.datetime} - previous({table.datetime}),0,"")
else
"N/A"

This w2orks unless you want to ignore the case where the status did not change, such as your 3rd row in the example, in which case you'd use:

If previous({table.billid}) = {table.bill}
and
{table.newstatus} <> "new"
and
{table.oldstatus} <> {table.newstatus} then
totext(({table.datetime} - previous({table.datetime})),0,"")
else
"N/A"

-k

 

[unknownly]

Thank you very much. I seem like working I still have to test with different cases