Forum Discussion
PowerQuery in Excel, data types
Hello, sometimes when I refresh my table and my query, I get an error message that "2023E"could not be converted into date format. I don't find any reason for this behavior. Maybe someone can help me. Thank you.
Hi excelfriend583u ,
It looks like your raw data was converted to be presented in scientific notation, what does your raw data look like?
If your original data structure is the same as the data I tested:You can directly convert the column to a date type directly when the column's data type is text:
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
- Omid_Motamedise
Super User
What is the query about, explain more
EinomiHelper V
Hi,
Can you share some screenshot of your query and error so that we can look into it ?
Hi excelfriend583u ,
It looks like your raw data was converted to be presented in scientific notation, what does your raw data look like?
If your original data structure is the same as the data I tested:You can directly convert the column to a date type directly when the column's data type is text:
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
