Categories
- All Categories
- 5 Oracle Analytics Sharing Center
- 12 Oracle Analytics Lounge
- 194 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.4K Oracle Analytics Forums
- 6K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 66 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Date arithmetic in a Data Flow

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?
Answers
-
Hi James- I believe what you're looking for is the TimestampAdd function under the Calendar/Date options in Data Flows. You should be able to specify things at the specific grain you want (day, month, etc.). Good luck!
Tim Vlamis
tvlamis@vlamis.com
0