Many times you want to use a date in the future or in the past to develop a query.  Let’s say you wanted to see how many inquiries you received during the past 30 days. Rather than figuring out the exact date, use a formula.

Instead of dates, you work with numbers separated by commas. The first number represents the days, the second the months and the third the years. Named days can also be used as well as the + and – signs to indicate future and past dates.

And in addition to this, did you know that when you enter a date the long way, there are some shortcuts?  Enter any number between 1 and 31 (or 30, 29, or 28 depending on the month) and ClientBase will assume you mean this month and year and will fill it in for you. Looking for a date later this year? Just type in 1015 (no slashes needed) and ClientBase will know you mean October 15, 2009.

These can be used in any date field: