When you create a filter condition that compares the date‑and‑time values in a cross tab to a specific date or dates, the date value must be in one of the following formats, regardless of your locale:

Figure 5‑16 shows how to select a date.