- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Can you post the screenshot of Start Time column of PQ before converting to datetime?

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
08-20-2024 07:48 AM | |||
04-02-2020 05:51 AM | |||
03-26-2024 02:47 PM | |||
08-22-2024 02:19 AM | |||
09-05-2024 10:12 AM |
User | Count |
---|---|
33 | |
18 | |
14 | |
11 | |
10 |