I have a list with all of our account records listed by date for example:

Joe X 6/1/2013

Jane X 6/3/2013

Sue X 6/5/2013

Mark X 6/5/2013

Sandy X 6/7/2013

 

If todays date was 6/5/2013, how would I create a line that would appear right above the first record "Sue" 6/5/13 and change everyday?

 

Thanks

Conditional formatting. Draw the line in the same color as the background, taking care to keep it in the Body, just above the fields of the record. Then set the condition to change to a visible color if the record date equals today's date, AND GetNthRecord(datefield;Get(RecordNumber) - 1) does NOT equal today's date.

 

That should give you the line for the first record of the current date, and only that record. It will change automatically every day.