Assuming nextrenewaldate is required, the following result was found.
Method #4: Combining method 2 & 3, we can reduce getting the ordinal to 2 lines plus the output: v_NextRenewalDate = '2018-11-06'; v_ThisDayDate = v_NextRenewalDate.toString("dd").toLong(); v_ThisDayDateLastChar =...