You are here

Selecting a Date or Time

Subscribe to Syndicate

When looking up date and time fields, clicking on the icon will produce the Calendar/Date Search window. If the criteria you are using searches a date field only, the time will not appear.


Calendar Functions

The date search window allows you to select any date to use as a parameter. You can select any date by simply double-clicking on it.

There are also navigation tools available to help you move forward or backward on the calendar:

Click this button to move the calendar back one month.
Click this button to move the calendar back one year.
Click this button to move the calendar forward one month.
Click this button to move the calendar forward one year.
Click this button to directly select from any of the upcoming 12 months, or the same month from the next 5 years.

Time Functions

To change the hour, you can click on the top of the field to forward an hour. it rolls from 12 back to 1. Click on the bottom to go back an hour.

For minutes, if you click the 'left' side, it will go up/down by 10 minutes at a time. If you click on the right side of the minute, it will go up/down a minute at a time. This provides both a "fast" and a "slow" mode of changing the time.

If you right click on any part of the hour, you can pick 1 to 12.

If you right click on any part of the minutes, you can quick set the time to the quarter hour (00, 15, 30 or 45)

If you click on the am/pm, it toggles. If you right click, you get to pick am or pm directly.