Forum Discussion
Power Query changing timestamp
I have an excel sheet with an "Opened Date" column and a "Closed Date" column. Both columns have full date and timestamp. When importing into Power Query, the "Opened Date" changes from correct tim...
Hi Anonymous
Try changing the date to datetime in smallcase as mentioned in the below screenshot or remove the highlighted part in green alltogether. This should solve your issue.
Hi Anonymous
Try changing the date to datetime in smallcase as mentioned in the below screenshot or remove the highlighted part in green alltogether. This should solve your issue.
Anonymous , thank you that resolved it!!!!