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 Anonymous ,
You can try to use format() by Custom date and time formats:
FORMAT(<value>, <format_string>) Please refer:
- Custom date and time formats for the FORMAT function
- Pre-defined date and time formats for the FORMAT function
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.