Forum Discussion

andrewb95's avatar
andrewb95
Icon for Helper II rankHelper II
6 years ago
Solved

If & Today operators

I am attempting to run a query so a new column will populate as TRUE if two statuses from one column are correct and the date is before the current date.    ie. I have:  A database where each cont...
  • andrewb95's avatar
    andrewb95
    6 years ago

    This worked however not all the parenthesis were needed:

    IF(Table1[COLUMNA] = "ITEM-1" || [Direction] = "ITEM-2" || && Table1[COLUMNB] < TODAY() ,TRUE(), FALSE())

     

    Thanks!

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

andrewb95 , Are these columns or table. If tables what is relation. Can share some sample data and explain with example

  • andrewb95's avatar
    andrewb95
    Icon for Helper II rankHelper II
    6 years ago

    It was all from columns within the same table, many thanks for attempting to support.