For my transaction list I have built in alteryx, I need to apply the last day of the current month. to make things even more complicated, I have to wait until the end of the month to create transactions list to I need it to be one month in arrears. For example, when I create my transaction list in Alteryx on 7/3/24, I need the 'Reporting Date' column to read 06/3/24.
Any ideas?
thanks,
In your example, you have 06/3/24 but you mention that last date of the month. Did you mean 6/30/24?
If so, you can use this formula to give you that last day of the previous month based on the day you run it,
datetimeadd(datetimetrim(DateTimeToday(),"Month"),-1,"days")