Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
In the above example I am extracting the date (in text format) in [Action] to [Last Update Date] using DATEVALUE(LEFT([Action],16)) I formated the date with dd/mm/yyyy, but I noticed that some of those dates are mm/dd/yyyy in some rows (in red) and others are correct (in green).
Can anyone help?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.