
Contributor III
2022-07-06
03:47 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
Labels (10)
Labels
- Subscribe by Topic:
-
Data Load Editor
-
Developers
-
dimension
-
expression
-
filter
-
General Question
-
Script
-
Set Analysis
-
Variables
-
Visualization
1,678 Views
- « Previous Replies
-
- 1
- 2
- Next Replies »
10 Replies


MVP
2022-07-06
05:37 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- « Previous Replies
-
- 1
- 2
- Next Replies »