Loading

DATEADD returns unexpected dates when using Oracle connections

Дата публикации: Dec 25, 2024
Описание

When using Oracle connections and adding months with DATEADD to the date field, the output data of the flow shows unexpected dates. 

For example, consider the calculated field:

DATEADD("month",6,[Order Date])

When "Order Date" is 2/28, the result of the calculation will be 8/31.

Решение

Option 1: Output the preceding part of the step with DATEADD calculation in the flow as an extract (.hyper file). Then connect to the hyper file as an input and use DATEADD function.

Option 2: Implement the desired logic in more detail, using functions like YEAR(), MONTH(), DAY(), and MAKEDATE().

Дополнительные ресурсы

Date Functions - Date functions available in Tableau - DATEADD

 

Номер статьи базы знаний

003962389

 
Загрузка
Salesforce Help | Article