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.
Anonymous , You can convert a DD/MM/YYYY date into MM/DD/YYYY like
date(year( right(DD__MM__YY[Version_Id],4)), month(mid(DD__MM__YY[Version_Id],4,2)) ,day(left(DD__MM__YY[Version_Id],2)))
But how would you identify that which format it is?
Or maybe all dates are in DD/MM/YYYY format is it just for days <=12 , it seems like it is MM/DD/YYYY