I am working on a reporting application and we fetch several records based on their start/end date ranges. Users can choose to leave both start and/or end dates blank.
Example 1 - Date: 1/15/2010 to 2/3/2011 Example 2 - Date: [blank] to 2/3/2011 Example 3 - Date: 1/1/2010 to [blank] Example 4 - Date: [blank] to [blank]
Example 1 reports on all records between Jan 1st 2010 and Feb 3rd 2011. Example 2 reports on any records that ended before Feb 3rd 2011. Example 3 reports on any records that started after Jan 1st 2011. Example 4 reports on all records.
What is the best thing to say for those [blank] spots? "Beginning of Time" and "Infinite Future" are technically not correct -- because you could set ended date to blank and start date to 1/1/1970 and get a record that ended in the 1980's - not exactly the 'infinite future' -- Also "Beginning of Time" and "Infinite Future" are quite long in terms of space.