Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Date arithmetic in a Data Flow — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Date arithmetic in a Data Flow

Received Response
10
Views
1
Comments
edited Sep 11, 2019 5:18AM in Oracle Analytics 1 comment

Summary

The functions available in the Data Flow tool do not provide arithmetic capabilities on dates.

Content

Hello, I uploaded a data set to the OAC, which includes a date field. I want to add a new date field which is 1 month later then the existing date column, resulting in a date range for each row. The Data Flow tool does not appear to offer date arithmetic functions. I tried add_months(<date>,1) but received an "invalid expression" error message. I am new to OAC, and searched the community, documentation and the Internet but could not find any answers. How can I perform this arithmetic in a data flow? 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!