Hi everyone,
I hope you'd be able to help me with an issue I have been struggling for over 1 hour now and can't figure out a solution.
So I have added a CSV query from a folder on my drive that has a date in this format: DD/MM/YYYY, but when I run the query and want to convert the date to week number, is shows an error " VALUE", which means this is not regocnized as a date on my excel ( someone else is saving that CSV file on the drive). MY standard date on my pc is american so MM/DD/YYY but I can't change as same situation would happen with another query for another report that I run.
Is there a way to convert these in the query to a correct date so I can get the right WEEKNUMBER?
Thanks!
Agata
I hope you'd be able to help me with an issue I have been struggling for over 1 hour now and can't figure out a solution.
So I have added a CSV query from a folder on my drive that has a date in this format: DD/MM/YYYY, but when I run the query and want to convert the date to week number, is shows an error " VALUE", which means this is not regocnized as a date on my excel ( someone else is saving that CSV file on the drive). MY standard date on my pc is american so MM/DD/YYY but I can't change as same situation would happen with another query for another report that I run.
Is there a way to convert these in the query to a correct date so I can get the right WEEKNUMBER?
Thanks!
Agata
