Create Field with month end date

[CDIns]

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, 

[SPetrie]

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

[binu_acs]

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