Tag Records with Month-end and Summarize

[StephenBurns]

I am attempting tag records with a month-end based on a specific date within the data set. For the below dates, I would like to generate a new field with the relative month-end for each record so I can summarize.

[johnemery]

I apologize if you saw my original message. I was in error.

Give this a shot: DateTimeAdd(DateTimeAdd(DateTimeTrim([dte],"month"), 1, "month"), -1, "day")

[StephenBurns · Accepted solution]

Thank you. I was able to use the below to get the result and then remove the text for the hour, minute, seconds.