Round date value to the last day of a month
SummaryHow to convert a given day to the last day of that month?
Have looked in the report functions (Functions (custhelp.com)) and actually I'm looking for the opposite of the trunc(ation) function. If you have a date, I want to convert that date to the last day of that month.
Say I have '12-05-2021' (dd-mm-yyyy as format), then I want to display it as '31-05-2021'. Can this be achieved and if so how?