Formula Fields

[sona123]

Hi All,
I have a scenario where I have to print records like following

transaction opentime closetime duration
1 10:30 11:00 30
2 11:00 11:20 25
3 11:20 12:00 40

as u observe the close time is opne time for next record.
There is only one database field the "opentime". Can this be done using formula field. Please help.

Thank You,
Sona.

 

[mbarron]

Create the following formula.

whileprintingrecords;
next({open.time})

You may be limited in some operations. You also won't have a close time for your last record because there will be no "Next" Mike

 

[sona123]

Thank you. That helped. I have to think about last record though.

Sona.

 

[sona123]

Thank you. That helped. I have to think about last record though.

Sona.

 

[sona123]

Thank you. That helped. I have to think about last record though.

Sona.

 

[sona123]

Thank you. That helped. I have to think about last record though.

Sona.

 

[mbarron]

If your last transaction is always open, you could use the following to capture the current time:

if onlastrecord then now
else next({open.time}) Mike