✅ Converting string to DateTimeOffset

public List<EntryModel> LoadEntries(User user)
{
    using SQLiteConnection conn = new(_dbFile);
    using SQLiteCommand cmd = conn.CreateCommand();
    SQLiteDataReader reader;

    conn.Open();

    cmd.CommandText = @"SELECT * FROM entries WHERE Username=$un";
    cmd.Parameters.AddWithValue("$un", user.Username);

    try
    {
        reader = cmd.ExecuteReader();

        List<EntryModel> allEntries = new();

        while (reader.Read())
        {
            string format = "MM/dd/yyyy";
            CultureInfo culture = CultureInfo.InvariantCulture;
            DateTimeStyles style = DateTimeStyles.None;

            int iden = Convert.ToInt32(reader["Id"].ToString());
            string username = reader["Username"].ToString();
            string title = reader["Title"].ToString();
            DateTimeOffset date;

            if (!DateTimeOffset.TryParseExact(reader["Date"].ToString(), format, culture, style, out date)
            {
                date = DateTimeOffset.Now;
                date.ToString("MM/dd/yyyy");
            }
            else
            {
                // convert correctly formatted string to a DateTimeOffset object
                string savedDate = reader["Date"].ToString();
                var splitDate = savedDate.Split("/");
                date = new DateTimeOffset(Convert.ToInt32(splitDate[0]), 1, 1).AddDays(Convert.ToInt32(date[1])-1);
            }
        }
    }
}

public List<EntryModel> LoadEntries(User user)
{
    using SQLiteConnection conn = new(_dbFile);
    using SQLiteCommand cmd = conn.CreateCommand();
    SQLiteDataReader reader;

    conn.Open();

    cmd.CommandText = @"SELECT * FROM entries WHERE Username=$un";
    cmd.Parameters.AddWithValue("$un", user.Username);

    try
    {
        reader = cmd.ExecuteReader();

        List<EntryModel> allEntries = new();

        while (reader.Read())
        {
            string format = "MM/dd/yyyy";
            CultureInfo culture = CultureInfo.InvariantCulture;
            DateTimeStyles style = DateTimeStyles.None;

            int iden = Convert.ToInt32(reader["Id"].ToString());
            string username = reader["Username"].ToString();
            string title = reader["Title"].ToString();
            DateTimeOffset date;

            if (!DateTimeOffset.TryParseExact(reader["Date"].ToString(), format, culture, style, out date)
            {
                date = DateTimeOffset.Now;
                date.ToString("MM/dd/yyyy");
            }
            else
            {
                // convert correctly formatted string to a DateTimeOffset object
                string savedDate = reader["Date"].ToString();
                var splitDate = savedDate.Split("/");
                date = new DateTimeOffset(Convert.ToInt32(splitDate[0]), 1, 1).AddDays(Convert.ToInt32(date[1])-1);
            }
        }
    }
}