Create Field with month end date

Question

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,

binu_acs · Answer

@CDIns I assume your date is in the format of mm/dd/yy

Reporting_Date_24062024.yxmd

SPetrie · Answer

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")