Reporting Month "date" change to Last Day of That Month

[michael_franz]

I have a field called "reporting month" that has a date of yyyy-mm-dd. The date can be any date of the year, but I need it to be the last day of that particular month. It needs to join with another data source and that data source only has ever used last day of the month.

[Federica_FF · Accepted solution]

Hi michael_franz

there is a function to calculate the last day of the month from any date:

DateTimeTrim([Date field],"lastofmonth")

Try to use it in a Formula tool

[michael_franz]

Thanks for the help... That did it. I have one question.. What did yo umean by

"Try to use it in a Formula tool"