Using specific date and time parameters

To use specific dates, enter the actual date to consider the parameter.

Examples:

• To use orders that were created on April 24, 2012, the query builder parameter is:
  • Order field: Order Date
  • Operator: =
  • First value: 4/24/12 (mm/dd/yy format)
• To use orders that were created on April 24, 2012 after 2:30 pm, the query builder parameter is:
  • Order field: Order Date
  • Operator: =
  • First value: 4/24/12 14:30 (time format must be 24-hour format)
• To search with time and date for date fields in Wave filter, the query builder parameter is:
  • Order field: Planned Delivery Date
  • Operator: BETWEEN
  • First value: NOW
  • Second value: NOW+3. Where NOW is the current date and +3 is time plus 3 hours.
    Note: 

    • You can save the search as a filter, which can be used for standard operations.
    • An error message is displayed, if you use the Now function when the operator field value is set to =.
• To search between specific time zone on the same day, the query builder parameter is:
  • Order field: Planned Delivery Date
  • Operator: BETWEEN
  • First value: TODAY 12:00:00
  • Second value: TODAY 14:00:00. Where TODAY is the current day.