Subject date conversion issue
Author d_dude_2003
I have the following statement

DELETE FROM HRM_ATTENDANCERAW
WHERE HRM_ATTENDANCERAW.ADATE < CURRENT_DATE - :DeleteRawAttendance;

DeleteRawAttendance is declared as INTEGER and is a configuration
variable taken from separate table.

The statement results in conversion error.

How do i correct it?

Thanks.