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.
rigth now I am facing an issue that I am not able to solve by myself. (All data is attached)
1. Issue: I would like to calculate the difference between two dates (2019-03-18 and the most recent date). This data input will be updated each month once and imports new dates within a new column (darte of end of most recent month). Now I would like to build a workflow that recognizes the most recent date (2020-08-31) and will then be substracted by the oldest date (2019-03-18).
2. Issue: I would like to calculate the date between the most recent month and the previous month. In this case (see data output below) this would be 2020-08-31 subtracted by 2020-07-31. Ideally, as described by issue 1, the workflow would recognize the most recent date (column) and the previous month automatically.
-> The results of issue 1 and 2 should be new columns.
This what i able to understand. You want subtract (2019-03-18 and the most recent date) and subtract 2020-08-31 subtracted by 2020-07-31 dynamically by finding recent date column, oldest date column, previous month of recent column.
Hi @grazitti_sapna thank you so much for your quick response. Its perfect that you already removed the unwanted columns. However, I cant open the workflow. Could you resend it in the .yxmd file format so I can open it with my version of Alteryx? I only need the Workflow as a stand alone .yxmd file.
Hi @atcodedog05 thank you for your workflow. Is it possible that you remove the irrelevant dates and also transform the differences between the dates in "Months"? I think right now the difference is shown in days. That would be awesome!