Matthew R White Posted June 19, 2013 Posted June 19, 2013 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
KaosMaker Posted June 19, 2013 Posted June 19, 2013 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.
Recommended Posts
This topic is 4177 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now