Use dates as criteria - Automate_Studio - Latest

Automate Studio with Studio Administrator User Guide

Product type
Software
Portfolio
Integrate
Product family
Automate
Product
Automate > Automate Studio
Version
Latest
Language
English
Product name
Automate Studio
Title
Automate Studio with Studio Administrator User Guide
Topic type
Administration
Overview
How Do I
Installation
First publish date
2018
ft:lastEdition
2024-03-11
ft:lastPublication
2024-03-11T17:14:05.914572

When you need to find records based on the values of a date field, Query provides several options.

  1. On the Workspace tab, click the Criteria check box for the date field, and then click the Criteria tab.
  2. Choose an operator for the date field.

  3. Click the calendar button in the values box, and do one of the following:
    • Click a date in the calendar.
    • Click the Empty Date Value box to return records that do not contain data for that field.
    • Click the SAP Default Initialize Date box to return records that still have the default date that was assigned by SAP.
    • Click the third box, and click a date value—for example, click Today or Start of Year. If you click Today, the date will update each day.

      You can also click an operator (+ or -) and type a value for a number of days in the boxes that appear (for example, Start of Year + 90 days).