CREATE OR REPLACE FUNCTION core.get_month_end_date(_office_id integer) RETURNS date LANGUAGE plpgsql AS $function$ BEGIN RETURN MIN(value_date) FROM core.frequency_setups WHERE value_date >= transactions.get_value_date($1); END $function$