Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 42 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 277 Oracle Analytics and AI News
- 54 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 19 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
How to create a date from a period field in OAC Dataflow (function DATE not available)
User_NVFN9
Rank 2 - Community Beginner
Hello everyone,
I’m currently working in the Dataflow menu of Oracle Analytics Cloud (OAC).
I’m trying to transform a period field that I derived from dates, in order to obtain a proper reference date in the format DD-MM-YYYY, starting on the first day of the period.
For example, for January 2025, my current field value 'Periode' is 20251, and I would like to convert it into 01-01-2025.
I tried using a formula in “Add a Column”, but it seems that the DATE() function does not exist in this environment.
Could anyone please help me with the correct approach or expression to achieve this?
Thank you very much,
Thomas
Tagged:
0