Forum Discussion
Date format
Hi, I have a dataset that updates everyday and columns with dates in them, however the format of these dates changes now and then. For example, sometime the entire column might be in the "MM/DD/Y...
Not off of the top of my head. If you can come up with some sort of business logic, I can assist with the Power Query side, but cannot think of a way for PQ to just know when 4/1/2020 is Jan 4 or April 1.
Hi edhans,
Thank you, this is really helpful. However, the issue is with dates like 4/1/2020 like you mentioned. Is there anything you can think of to solve that?
Not off of the top of my head. If you can come up with some sort of business logic, I can assist with the Power Query side, but cannot think of a way for PQ to just know when 4/1/2020 is Jan 4 or April 1.