In my report I am working getting what I need when I read the first Record, but I am need the date from the last record (Date2) to appear on the report on the first line. The below is an example:

right click on Formula field->new->write a formula name->OK

then write this code:

if OnLastRecord then
{your table name.your field name}

I hope this will be help full for you..

Edited by zanyar-Jalal - 19 Sep 2012 at 8:11pm

Thank you guys....didn't even think about that and it seems like a perfect way to handle this issue! Many Thanks!