SAP Knowledge Base Article - Public

3419254 - SAC Query Date Range Issue

Symptom

When creating a date range in a query, the start date is set to one day previous and the end date is set to a day ahead.

Environment

SAP Analytics Cloud 2023.21.8

Reproducing the Issue

  1. Access the Model.
  2. Go to Data Management.
  3. Edit the Import Job.
  4. Go to Edit -> Query.
  5. In the "Filters" section, add a date range. For example: December 1st to December 31st.
  6. Click on "Next" and "Save".
  7. Go again to "Edit -> Query".
  8. You'll notice that the date range is different than what you set.

Cause

This issue is currently being investigated by the Development Team.

Resolution

This issue is currently being investigated by the Development Team.

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

SAP Analytics Cloud, SAC, sapanalyticscloud, kba, note, help, knowledge, model, modeling, connection, tenant, version, data management, import job, query, date, date range, range, issue, error, day, month, year, edit, set , KBA , LOD-ANA-ML , SAC Modelling , Bug Filed

Product

SAP Analytics Cloud 1.0