This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I been trying to figure out why part of this is working correctly and part is not. I am needing to populate a cell if the cancel date is greater than 400 days from today's date. I have tried rearranging the order of the formula and that is not working. Please see an example workflow attached and hopefully someone can tell me why this is not working for all rows.
you have to convert the date in the [CAN_DT] column to a proper date format - then you can use DateTimeDiff to calculate the difference between today and the cancel date. I've modified your workflow a bit. Hope it works now as expected.