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

Knowledge 기사 번호

003962389

 
로드 중
Salesforce Help | Article