Date format Changes
Hi @GrantSmith ,
This is the date format I have in the dataset :
I wanted to remove the C and have it in text to alter it as Date :
Thus I used this formula on the formula tile (RIGHT(Date
, 10)) and got it in :
However I tried using the Alter tile and Formula tile (STR_TO_DATE(Date
, '%Y-%m-%d')) which did not work, giving me this error message below :
Appreciate your kind help!
Best Answer
-
Based on the error message, it looks as though one of your rows contains a value of LAST_RUN and not any form of a date. You can try and handle this two different ways. In your formula tile, you can try wrapping a TRY_CAST function around your STR_TO_DATE function like this:
TRY_CAST(STR_TO_DATE(
Date
, '%Y-%m-%d') as DATE)This will attempt to convert it to a date field and if it can't it will just make the value null.
In the alter tile, click on the settings cog next to the cast data type and select Null in the Bad Values dropdown list. This will do the same thing as above, as it will make the value null if it can't convert it to a date for you.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0
Answers
-
Based on the error message, it looks as though one of your rows contains a value of LAST_RUN and not any form of a date. You can try and handle this two different ways. In your formula tile, you can try wrapping a TRY_CAST function around your STR_TO_DATE function like this:
TRY_CAST(STR_TO_DATE(
Date
, '%Y-%m-%d') as DATE)This will attempt to convert it to a date field and if it can't it will just make the value null.
In the alter tile, click on the settings cog next to the cast data type and select Null in the Bad Values dropdown list. This will do the same thing as above, as it will make the value null if it can't convert it to a date for you.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0
Categories
- All Categories
- 1.5K Product Ideas
- 1.5K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 280 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.7K Transform
- 90 SQL DataFlows
- 563 Datasets
- 2K Magic ETL
- 3.4K Visualize
- 2.3K Charting
- 592 Beast Mode
- 13 App Studio
- 28 Variables
- 588 Automate
- 143 Apps
- 417 APIs & Domo Developer
- 27 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 361 Distribute
- 99 Domo Everywhere
- 260 Scheduled Reports
- 2 Software Integrations
- 94 Manage
- 91 Governance & Security
- 9 Product Releases
- Community Forums
- 37 Getting Started
- 28 Community Member Introductions
- 90 Community Announcements
- 4.8K Archive