Forum Discussion
Custom date format with date data type
Hi pozzyal,
Based on my research, I find that there is no region which use date format like mm.dd.yyyy(if your date is mm.dd.yyyy, you could change this to date type by = Table.TransformColumnTypes(Source, {{"Column1", type date}}, "es-PA") in M code, but you can't change type to mm.dd.yyyy). You could refer to this link for details. So we can't use built-in date format, we need to use format expression which convert type to text.
So I suggest you could use date type to calculate result , use mm.dd.yyyy as text column to show in table.
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi pozzyal,
Based on my research, I find that there is no region which use date format like mm.dd.yyyy(if your date is mm.dd.yyyy, you could change this to date type by = Table.TransformColumnTypes(Source, {{"Column1", type date}}, "es-PA") in M code, but you can't change type to mm.dd.yyyy). You could refer to this link for details. So we can't use built-in date format, we need to use format expression which convert type to text.
So I suggest you could use date type to calculate result , use mm.dd.yyyy as text column to show in table.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.