Hello!

How could I possibly create a new date variable in the monthly format for the data example below?

Thankfully,
Anton
Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input float product_id str9 date
 1 "26-Apr-17"
 1 "1-Sep-19" 
 1 "8-Aug-17" 
 1 "12-Jan-18"
 1 "27-Mar-17"
 1 "12-Nov-18"
 1 "9-Sep-17" 
 1 "15-Nov-18"
 1 "24-Aug-17"
 1 "2-Jan-17" 
 1 "13-May-17"
 1 "30-Jan-19"
 1 "25-Sep-18"
 1 "13-Sep-16"
 1 "2-Jul-19" 
 1 "18-Sep-18"
 1 "23-Nov-17"
 1 "24-Oct-19"
 1 "24-Aug-19"
 1 "28-Jan-17"
 1 "22-Feb-18"
 1 "29-Jan-17"
 1 "14-Apr-19"
12 "28-Aug-14"
14 "28-Aug-17"
16 "30-Jan-16"
16 "23-Dec-16"
16 "18-Sep-15"
16 "22-Aug-14"
16 "15-Sep-14"
16 "23-Sep-13"
16 "12-Jan-15"
16 "13-Jan-16"
16 "10-Nov-16"
16 "9-Jan-18" 
16 "7-Dec-14" 
16 "6-Jul-12" 
16 "15-Apr-18"
16 "27-Dec-12"
16 "22-Feb-16"
16 "11-Mar-15"
16 "4-Nov-14" 
16 "12-Mar-15"
16 "24-Nov-14"
16 "24-Apr-15"
17 "29-Nov-15"
17 "5-Mar-16" 
17 "11-Dec-17"
17 "26-Aug-19"
17 "22-Jun-17"
end