datetime not converting correctly when running python script

yohanhwang — Mon, 23 Jan 2023 19:24:24 GMT

Hi.

So I get an error that says:

DataSource.Error: ADO.NET: Python script error.
<pi>ValueError: time data 'Microsoft.OleDb.Date' does not match format '%m/%d/%Y'
</pi>

when running the following portion of my python script in power query editor:

result = [] for value in dataset["elcn_contributiondate"]: if (datetime.strptime(value, '%m/%d/%Y') >= pd.Timestamp(2018,7,1,12)) & (datetime.strptime(value, '%m/%d/%Y')<= datetime.datetime.now() - relativedelta(years=4)): result.append('FY2018') elif (datetime.strptime(value, '%m/%d/%Y') >= pd.Timestamp(2019,7,1,12)) & (datetime.strptime(value, '%m/%d/%Y')<= datetime.datetime.now() - relativedelta(years=3)): result.append('FY2019') elif (datetime.strptime(value, '%m/%d/%Y')>= pd.Timestamp(2020,7,1,12)) & (datetime.strptime(value, '%m/%d/%Y') <= datetime.datetime.now() - relativedelta(years=2)): result.append('FY2020') elif (datetime.strptime(value, '%m/%d/%Y') >= pd.Timestamp(2021,7,1,12)) & (datetime.strptime(value, '%m/%d/%Y') <= datetime.datetime.now() - relativedelta(years=1)): result.append('FY2021') elif (datetime.strptime(value, '%m/%d/%Y') >= pd.Timestamp(2022,7,1,12)) & (datetime.strptime(value, '%m/%d/%Y') <= datetime.datetime.now()): result.append('FY2022') else: result.append('no year') dataset['FY'] = result

No matter what other version of datetime I try it still errors out. Any help would be greatly appreciated.

topic datetime not converting correctly when running python script in Developer

datetime not converting correctly when running python script