I am using Apache Phoenix Query Server. I need to manipulate the payment_status column so that it follows the logic below and be corrected. However, I noticed that even when paid_date is equal to now_date, the converted status (new_payment_status) becomes “Overdue” instead of “Due”. Any ideas why was that happening? Result and Metadata: Edit: Embeded a screenshot instead, because markdown