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 am trying to eliminate all rows of data that do not fall within a predefined reporting period. I have a column of data which has the 'Transaction date' in date format yyyy-mm-dd.
I now want to input 2 variables into my workflow, one that is 'Start date', one that is 'End date' then use a formula to eliminate rows if the date value doesn't fall within this range - is this possible?
Actually no, only setting the range is enough. Alteryx displays the dates as you want them to be visible, but the data for him is the same (as long as both have the same amount of data, meaning both have 'year month day' or 'year month day hour'.
Therefore, this should be enough:
[DateTime.entry] >= [DateTime.start] AND [DateTime.entry] <= [DateTime.end]