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().

ナレッジ記事番号

003962389

 
読み込み中
Salesforce Help | Article