Log In
Register
Home
Active Member
March 17, 2021
Offline
HI,
iam new to power query. When i want to load data to excel file from power query, Date column (pre 1900 years) not loading properly into Excel sheet. Go through the attachment (E column) & suggest me the way to solve it.
regards
raj kumar
October 5, 2010
Offline
Hi Raj,
Can you please explain what you mean by dates prior to 1900 are not loading properly.
Looking at your file I see a column of dates. But most of these are negative values (date serial numbers) and you can't have negative dates. If that's the issue then you need to fix these dates to be valid.
Regards
Phil
July 16, 2010
Offline
Hi Raj,
Excel doesn't recognise dates prior to January 1, 1900, however Power Query can work with dates prior. So, while working with the dates in Power Query make sure they are data type: date. Then before loading to Excel you need to convert the column containing dates prior to January 1, 1900 to data type: Text so that they can be displayed in Excel as a date. Note: you won't be able to perform any calculations on these dates in the Excel table as they'll be text.
Mynda
1 Guest(s)
