HenryJSPost Prodigy6 years agoSolvedIF 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 Show Moreaz386 years agoHi HenryJS try a column Column = IF([Document] = "Self Billing Agreement" && DATEDIFF([docexpiry], TODAY(), MONTH) <= 1, "Yes", "No")
az386 years agoHi HenryJS try a column Column = IF([Document] = "Self Billing Agreement" && DATEDIFF([docexpiry], TODAY(), MONTH) <= 1, "Yes", "No")
az386 years agoHi HenryJS try a column Column = IF([Document] = "Self Billing Agreement" && DATEDIFF([docexpiry], TODAY(), MONTH) <= 1, "Yes", "No")
az38Community Champion6 years agoHi HenryJS try a column Column = IF([Document] = "Self Billing Agreement" && DATEDIFF([docexpiry], TODAY(), MONTH) <= 1, "Yes", "No")
Related contentChange text date to a date typeText to date datatypeConverting from Text to DateConvert text to dateGet Date As Text
Post ProdigyPost Prodigy
Post Prodigy
