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.
Solved! Go to Solution.
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")
Thank you. I was able to use the below to get the result and then remove the text for the hour, minute, seconds.