Using date from a field for "last updated" date

[former_member824760]

hello,

Using date from a field for "last updated" date

i want to use date(starting from second entry) from another column as the initial date for another column.

for example

starting date last date

4/5/21 7/5/21

7/5/21 9/5/21

9/5/21

here last date column is using second entry from starting date. i am new to crystal reports so please help me out.

[DellSC]

Assuming that you're doing this within a group and you need to "restart" the date calculation every time the group changes, you'll use a formula similar to this to get the start date:

If OnFirstRecord or {group field} <> previous({group field}) then
  {MyTable.StartDate}
else
  previous({MyTable.EndDate})

Use this formula on the report instead of the start date field.

-Dell