Hi,
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:
=IF(M2>DATEVALUE("10/31/18"),TRUE,FALSE)
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?
Thank you!
Solved! Go to Solution.
Hi @BJSOON ,
Please find attached the alteryx workflow for your requirement.
I have used the below formula to get last day of previous month.
Thanks,
Sumit
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?
DateTimeAdd(DateTimeFirstOfMonth(),-0,'months')
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.
thank you! I got the desired results!
thank you! Let me try this out too.