2 Replies Latest reply on Feb 14, 2018 4:24 AM by Vasudeva Veeragandham

    Need help with adding intervals to date

    Vasudeva Veeragandham

      Hi Team,

       

      I need help with resolving issue with struggling to re write the below sql into Tableau .

       

      Can any one help me to solve it .

       

      evnp.reporting_trans_t >= to_date(:P_RUNDATE, 'YYYY-MM-dd') - INTERVAL '90' DAY

          AND evnp.reporting_trans_t   < to_date(:P_RUNDATE, 'YYYY-MM-dd') + INTERVAL '1' DAY