Month Name as Text
How can i format a date to Month Name as have it as Text not Date?
Reason why I ask is because I am creating a table in Domo that is going to have a Grand Total Row, as per a previous topic of mine, the Grand Total Row will have a calulation for percentage.
Β
So what I need to do is convert the Month Name into a text field so I can append the Grand Total Row to it. Hope that makes sense.
0
Comments
-
You should be able to use something like this:
MONTHNAME(`datecolumn`)
Example: MONTHNAME('2018-05-20') would return 'May' as the result.
Β
https://www.w3resource.com/mysql/date-and-time-functions/mysql-monthname-function.php
Β
Hope that helps,
Valiant
2
Categories
- 10.6K All Categories
- 1 APAC User Group
- 12 Welcome
- 36 Domo News
- 9.6K Using Domo
- 1.9K Dataflows
- 2.4K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 339 Workbench
- 252 Domo Best Practices
- 11 Domo Certification
- 461 Domo Developer
- 47 Domo Everywhere
- 100 Apps
- 703 New to Domo
- 84 Dojo
- Domopalooza
- 1.1K ζ₯ζ¬ζ―ι¨
- 4 ιε ΄-ζ₯ζ¬ζ―ι¨γΈγγγγ
- 22 γη₯γγ
- 63 Kowaza
- 296 δ»²ιγ«ηΈθ«
- 649 γ²γγγε ±ζ