deltatime calculation

[D_frucht]

hello.

i have problems with delta time calc. there are 2 relevant var, that a user input: date of order and number of weeks to deliver the order.

another var is the calculated date (order date + weeks to deliver)

import sqlite3
import datetime

conn = sqlite3.connect('dfsl.db')
c = conn.cursor()


def create_table():
    c.execute("CREATE TABLE IF NOT EXISTS orders (Client TEXT, Model TEXT, Quantity TEXT, Order_date DATE, Delivery_date INTEGER, Delivery_date_c DATE)")
    conn.commit()


def dynamic_data_entry():
    client = input('Please enter client name: ')
    model = input('Please enter model name: ')
    quantity = input('Please enter quantity: ')
    order_date = input('Please enter order date YYYY-MM-DD: ')
    delivery_date = int(input('Please enter number of weeks fot delivery date: '))
    delivery_date_c = datetime.date(order_date) + datetime.timedelta(weeks=delivery_date) # str(datetime.timedelta(weeks=delivery_date))


    c.execute("INSERT INTO orders (Client, Model, Quantity, Order_date, Delivery_date, Delivery_date_c) VALUES (?, ?, ?, ?, ?, ?)",
              (client, model, quantity, order_date, delivery_date, delivery_date_c))

    conn.commit()

def read_from_db():
    c.execute('SELECT client, model, quantity, delivery_date_c FROM orders')

    for row in c.fetchall():
        print(row)

create_table()

dynamic_data_entry()

read_from_db()

conn.close()