var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Search two fields for dates
I have an absentee database that needs a report to show absentees from that day forward.
I.E. John Smith called off on 3/12/2012
- he is off indefinitely - they enter an end date of 12/31/2012
My report needs to search the two fields - Start Date and End Date to find all of the dates that are equal to today and every day in between.
In other words, John smith needs to stay on this list until he returns to work. Thanks!
Solved my own issue by simply searching the end date field for any date that was greater than or equal to today. Maybe it will help someone else. Thanks.