Loading

DATEADD returns unexpected dates when using Oracle connections

Date de publication: Dec 25, 2024
Description

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.

Résolution

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

Numéro d’article de la base de connaissances

003962389

 
Chargement
Salesforce Help | Article