time data '202307' does not match format '%Y%m%d' about patent_client HOT 6 CLOSED

try:
    #fname = cur.execute("SELECT * FROM meta").fetchone()[0]
    # fetchone only gets the first entry in META which holds not necessarily the file from the latest week
    # at least when I manually edited the meta table to see what happens when file name is an old one
    fname = cur.execute("SELECT * FROM meta").fetchall()
    
    # initiate lists of legal_code_descriptions filenames
    date_strings = []
    
    #date_string = re.search(r"legal_code_descriptions_(\d+)\.xlsx", fname).group(1)
    # step though all rows in meta to collect all dates (years and weeks) in lists
    for name in fname:
        #print (name[0])
        date_string = re.search(r"legal_code_descriptions_(\d+)\.xlsx", name[0]).group(1)
        
        # collect all date_strings
        date_strings.append(date_string)
        
    #print (date_strings)
    
            
    # when tested on 22. Feb 2023 the date/time appended to the EPO excel file has format "YYYYWW"
    # e.g. legal_code_descriptions_202307.xlsx, i.e, week 7 in 2023
    # therefore testing for "%Y%m%d" caused an error that has to be captured
    # note: file was updated by EPO on Wed 23.02.2023 to legal_code_descriptions_202308.xlsx 
    try: 
        # keep this code piece in case EPO changes format back
        date = datetime.datetime.strptime(date_string, "%Y%m%d").date()
        age = datetime.datetime.now().date() - date
        logger.debug(f"Legal Code Database is {age} days old")
        return age.days <= 30
    
    except:
        # initiate date_max that gets the latest date (year and week) from the Excelfile
        date_max = 0
        
        # get latest year and week from dates in META
        date_max = max(date_strings)
        
        # parse date_max for most recent year and week
        year = int(date_max[:4])
        week = int(date_max[4:])

        # get current year and week
        current_year = datetime.datetime.now().isocalendar()[0]
        current_week = datetime.datetime.now().isocalendar()[1]
        # check if year is the same
        if current_year == year :
            age = current_week - week
        else: # when old file is from week 52 or 53 of previous year then it might be outdated
            age = 2
        logger.debug(f"Legal Code Database is {age} weeks old")
        return age < 1

except (sqlite3.OperationalError, TypeError):
    return False