Forum Discussion
Converting Datetime from Excel applies incorrect date
I have a bunch of logs that I need to combine, each is a excel file with no tables and a bunch of timestamps. The timestamps are datetime in excel, the datevalue includes the date.
When I try to convert the column to datetime from text, the time is correct but the date is not.
It's showing as 12 April instead of 4 April.
Is there a way I can get it to reflect the datetime as per the Excel cell value?
These reports are in .xls format.
2 Replies
@Vijay_A_Verma - sorry not sure if I replied correctly.
Here is the column before transformation.I'm using a workaround by appending the date to the filename via microsoft flow, then I leave start/end times as time with no date, and extract the date from the filename.
I then generate a time series with hours and minutes, join the start time on that, join the date on the calendar and it all comes together nicely.
Can you post the screenshot of Start Time column of PQ before converting to datetime?
