Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

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

Selecting Previous Thursday/Preceding Friday, regardless of run date

Received Response
179
Views
14
Comments
2»

Answers

  • Alexandru Burcea-Oracle
    Alexandru Burcea-Oracle Rank 3 - Community Apprentice

    Hi,

    You can also try a logic similar to below one

    CASE WHEN

    DAYOFWEEK(CURRENT_DATE)>=5

    THEN TIMESTAMPADD(SQL_TSI_DAY, 5-DAYOFWEEK(CURRENT_DATE) , CURRENT_DATE

    ELSE TIMESTAMPADD(SQL_TSI_DAY, -2-DAYOFWEEK(CURRENT_DATE) , CURRENT_DATE)

    END

  • Alexandru Burcea-Oracle
    Alexandru Burcea-Oracle Rank 3 - Community Apprentice

    Hi,

    You can also try a logic similar to below one

    ================================================

    CASE WHEN

    DAYOFWEEK(CURRENT_DATE)>=5

    THEN TIMESTAMPADD(SQL_TSI_DAY, 5-DAYOFWEEK(CURRENT_DATE) , CURRENT_DATE

    ELSE TIMESTAMPADD(SQL_TSI_DAY, -2-DAYOFWEEK(CURRENT_DATE) , CURRENT_DATE)

    END

  • Alexandru Burcea-Oracle
    Alexandru Burcea-Oracle Rank 3 - Community Apprentice

    Hi,

    You can also try a logic similar to below one

    ================================================

    CASE WHEN

    DAYOFWEEK(CURRENT_DATE)>=5

    THEN TIMESTAMPADD(SQL_TSI_DAY, 5-DAYOFWEEK(CURRENT_DATE) , CURRENT_DATE

    ELSE TIMESTAMPADD(SQL_TSI_DAY, -2-DAYOFWEEK(CURRENT_DATE) , CURRENT_DATE)

    END

  • Alexandru Burcea-Oracle
    Alexandru Burcea-Oracle Rank 3 - Community Apprentice

    Hi,

    You can also try a logic similar to below one

    ================================================

    CASE WHEN

    DAYOFWEEK(CURRENT_DATE)>=5

    THEN TIMESTAMPADD(SQL_TSI_DAY, 5-DAYOFWEEK(CURRENT_DATE) , CURRENT_DATE

    ELSE TIMESTAMPADD(SQL_TSI_DAY, -2-DAYOFWEEK(CURRENT_DATE) , CURRENT_DATE)

    END