Need help for date type conversion in python script to manipulate data?

[Suvechha]

Hi @c-rob ,

Thanks for your reply.
I am trying to build a logic where Timesheet Date in DSR table needs to compare with Date Start and Date End.

Thus trying to use Python for data manipulation.

I have a PBI question in the below link

Creating Measures without common relationship??

and also in Python

How to get the logic to be included in Python sample code

have got two df1 and df2 which has a field key contains multiple rows. If the key match in both data frames then I need to calculate the field Qualified. Qualified = CASE WHEN Timesheet Date >=Date Start && Timesheet Date <= Date End Comments contains "L" then "Learner" WHEN Timesheet Date >= Date Start && Timesheet Date <= Date Expiry then "Qualified" WHEN Timesheet Date >=Date End && Date Expiry = null then "Not Qualified" WHEN Timesheet Date < Date Start then "Learner" I…

Will you able to have a look and help please