Right string operation to remove the timestamp

I have a long date that I have converted to a text. Now I want to use the string operations tile to cut off the tail so I can have a nice clean date. the way it looks now in a string format is:
2022-02-24T12:08:34
What I want is:
2022-02-24
What I have been trying is:
But it leaving the date unchanged and that timestamp at the end is still there.
Thx
Best Answer
-
That looks correct. Are you looking at the newly named column for your result as it won't affect the original column.
A better option might be to use the Formula tile and use the date function to extract the date from your field. It would look like this:
DATE(`drentlastchanged`)
This will not only produce just the date, but will make it a date column that will be more usable at the card level.
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.1
Answers
-
@MarkSnodgrass Son of a gun you are right. The dataset has a ton of columns and I wasn't looking for the new column to be at the end of the columns. I was just referring to the existing column. Thanks!
0
Categories
- 10.8K All Categories
- 3 Private Company Board
- 1 APAC User Group
- 12 Welcome
- 38 Domo News
- 9.7K Using Domo
- 1.9K Dataflows
- 2.5K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 343 Workbench
- 258 Domo Best Practices
- 11 Domo Certification
- 464 Domo Developer
- 50 Domo Everywhere
- 104 Apps
- 714 New to Domo
- 85 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 26 お知らせ
- 64 Kowaza
- 299 仲間に相談
- 653 ひらめき共有