How do I specify dates through the Advanced button?

In the Additional Criteria text box, enter the SQL code in the following format:
<date column name>= to_date('<date>', 'dd-mon-yyyy')
<date column name> must be the technical name, and the <date> must be in the format of DD-MON-YYYY.

To find the technical name of the column, click on the Report Object name link, and locate the date column that you want to use in your query. The technical name is listed after the label. You can also click on the column label to get the technical name.

• For a single date:
  
  CMCN_DT=to_date('06-JUL-1998', 'dd-mon-yyyy')
  where CMCN_DT is the technical name and '06-JUL-1998' is the date.
  
  
  
• For more than one date:
  
  CMCN_DT=to_date('06-JUL-1998', 'dd-mon-yyyy') OR CMCN_DT=to_date('25-SEP-2000', 'dd-mon-yyyy')
  where CMCN_DT is the technical name and '06-JUL-1998' and '25-SEP-2000' are the dates.
  
  
  
• For dates after a particular date:
  
  The start date not included:
  CMCN_DT>to_date('06-JUL-1998', 'dd-mon-yyyy')
  
  The start date included:
  CMCN_DT>=to_date('06-JUL-1998', 'dd-mon-yyyy')
  
  where CMCN_DT is the technical name and '06-JUL-1998' is the date.
  
  
  
• For dates before a particular date:
  
  The start date not included:
  CMCN_DT<to_date('06-JUL-1998', 'dd-mon-yyyy')
  
  The start date included:
  CMCN_DT<=to_date('06-JUL-1998', 'dd-mon-yyyy')
  
  where CMCN_DT is the technical name and '06-JUL-1998' is the date.
  
  
  
• For a range of dates:
  
  CMCN_DT between (to_date('06-JUL-1998', 'dd-mon-yyyy')) AND (to_date('25-SEP-2000', 'dd-mon-yyyy'))
  where CMCN_DT is the technical name and '06-JUL-1998' and '25-SEP-2000' are the dates.