7 Replies Latest reply on Jul 5, 2016 2:11 PM by sameer.palladwar

    logical test with today() -1 = stored date then sales

    sameer.palladwar

      hi folks,

       

      I have field in database 'calday' which maps to fiscal months and fiscal days. for eg -

       

      I want to check if current date -1 = calday and fiscal month = current mont and fiscalday <= currntday then sales

       

      i have done same mapping in tableu for current date -1 but it is an inefficient way to do, please suggest