How can we delete previous years from calendars

Products

• CA Workload Automation AE - Scheduler (AutoSys)

Issue/Introduction

Noticed in our calendars that it still contains dates of years back to 2013.

How can we remove these previous years ?

Environment

Release : 12.0

Component : CA Workload Automation AE (AutoSys)

Resolution

Run following SQL statement to check out the date format used in your database if this is DD/MM/YYYY or MM/DD/YYYY

select * from ujo_calendar where day between '01/01/2021' and '02/02/2021';

To delete all days from all your calendars from begin 2013 till end 2020 in one go, execute this SQL statement using correct date format. 
Format MM/DD/YYYY is being used.

delete from ujo_calendar where day between '01/01/2013' and '12/31/2020';
commit;