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!

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

andrewb95 

Try below code as  new column

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

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon if you like this reply šŸ™‚

YouTube, LinkedIn 

  • andrewb95's avatar
    andrewb95
    Icon for Helper II rankHelper II
    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!