Forum Discussion

sccoleman1189's avatar
sccoleman1189
Helper I
6 years ago
Solved

Create new column based on conditions

I need help with something im sure is very simple.

 

I have two columns: create date and appointment date

 

What I want:

if appointment dat =create date +1 then 1, if not, 0

 

Thanks!

Need Help
  • parry2k's avatar
    parry2k
    6 years ago

    sccoleman1189 add a new column with the following expression:

     

    Flag = IF ( Table[Appt Date] = Table[Create Date] + 1, 1, 0 )

     

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

2 Replies

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    sccoleman1189 add a new column with the following expression:

     

    Flag = IF ( Table[Appt Date] = Table[Create Date] + 1, 1, 0 )

     

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!