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'm trying to add a column to indicate whether the "Effective Date" is in the current or future month (i.e. TRUE) or previous month (i.e. FALSE), using last day of previous month's date in the formula. The Excel formula looks like this:
I want to:
1. set the date value to always check for last day of previous month instead of having to change it each time the report is run in Alteryx.
2. find out how to convert the Excel formula (bearing in mind point 1) in Alteryx?
Hi Sumit, this works! Thank you so much! I have another question on date formula. I tried the following formula to get all the June records, however, it keep missing the 1st and 2nd June records which exist in my input file. It only returned records for 3rd June and onwards. What did I miss?
Thanks. How do I formulate it to check for 1st of every month? For e.g. when I run the report any time in June, I want the results to return 1st June onwards. When I run the report any time in July, I want the results to return 1st July onwards.