Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
xyz2
Contributor III

Change Date Format

Hello,

I would like to change the Date Format

"2022-05-23T11:11:42.397Z" 

to

"23.05.2022" (DD.MM.YYYY)

Does anyone know, how i can solve this problem?

 

10 Replies
Or
MVP

If you had to use Left(11) to get the full date, there's probably an extra character in there that isn't showing, because the date itself only takes ten characters - four for the year, two for the month, two for the day, and two for the dashes. You should be getting the date with the T after it if you use 11. Try isolating that problem character and adjust the formula as required to get rid of it or work around it.