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.
So the main reason why you're encountering issues has to do with how Alteryx stores dates compared to Excel. In Excel, dates are stored as a number (with 1/1/1900 mostly being day 1), and Excel translating this number into a human readable date.
Alteryx treats dates as a distinct data type, and has specific functions which are used to interact with this data type. The key advantage of this is that Alteryx can handle a much wider range of dates (try entering 1/1/1700 into excel, or doing date calculations with it).
To exactly replicate your current design, I would use the following formula for your MOD function:
Datetimediff() will return a number, in this instance the number of days since 1/1/1900, which is the starting point for all Excel calculations. We then Add two, because this calculation would otherwise start at 1/1/1900 as 0 instead of 1, and would only count the difference in days, so it would exclude the current date.
To create your entire formula, I would recommend the following: