Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 44 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 56 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 20 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
element calculated in the selection steps
User_I0GH4
Rank 3 - Community Apprentice
I would like to know if it is possible to make this element calculated in the selection steps instead of choosing the year which will change each year. Thanks
SELECT "Période conclusion de contrat"."Exercice financier conclusion contrat" FROM "SEAO" WHERE ( ( ( ("Période conclusion de contrat"."Exercice financier conclusion contrat" IN (cast(year(TIMESTAMPADD(SQL_TSI_MONTH, -3, current_date) )-2 as char(4) ) || '-' || cast(year(TIMESTAMPADD(SQL_TSI_MONTH, -3, current_date) )-1 as char(4) ) ) ) ) ))
0