Forum Discussion

HenryJS's avatar
HenryJS
Icon for Post Prodigy rankPost Prodigy
6 years ago
Solved

IF Text and Date

Hi all,

 

How can I create a column which states Yes IF:

  • Document = Self Billing Agreement
  • docexpiry is in the next 1 month

 

Thank you

 

 

Data Protection
Need Help
Show and Tell
Tips and Tricks
  • az38's avatar
    az38
    6 years ago

    Hi HenryJS 

    try a column

    Column = 
IF([Document] = "Self Billing Agreement" && DATEDIFF([docexpiry], TODAY(), MONTH) <= 1, "Yes", "No")

1 Reply

  • az38's avatar
    az38
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Hi HenryJS 

    try a column

    Column = 
IF([Document] = "Self Billing Agreement" && DATEDIFF([docexpiry], TODAY(), MONTH) <= 1, "Yes", "No")