Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Starting date = 1st day of a specific month (financial year)

Received Response
101
Views
12
Comments
2»

Answers

  • 3283263
    3283263 Rank 3 - Community Apprentice

    Hi All,

    I have found the Fiscal year option in the date folders. My issue is sometimes the date does not have any folder: we cannot chose which format of the date we want date, week, fiscal,...So would it be possible to apply a formula or filter on my date and say 'I want to have the current financial year' OR 'I want to start from the first day of the current financial year'?

    I know with TIMESTAMPADD we can do first day of month, first day of week, etc. can we do first day of financial year?

    Thank you very much.

  • Gianni Ceresa
    Gianni Ceresa Mod

    If you read the answers to the thread you find it!

    An OBIEE formula giving you the fiscal year start from any given date is posted on the 6th answer...

    And again: it's all about math how to get it, not really an OBIEE issue as the tool gives you the functions to add/subtract periods to a date etc.