Loading

DATEADD returns unexpected dates when using Oracle connections

Fecha de publicación: Dec 25, 2024
Descripción

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.

Solución

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

Número del artículo de conocimiento

003962389

 
Cargando
Salesforce Help | Article