How to always correct the date to the 1st.
Hello all,
I want to know the code for ETL "Add Formmura" function.
The column ”Data” will always contain a value for the year, month, and date.
When the value comes in , I want to set the date value always to 1st by using " Add Formmura" function in ETL as like below picture.
Could you let me know the code to enter into Add Formmura?
Thank you.
Best Answer
-
2
Answers
-
There’s many ways to do this. One way is to select the last day of the month and then subtract the day number of the month minus one
LAST_DAY(`Date`) - INTERVAL (DAYOFMONTH(`Date`) - 1) DAY
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1 -
@GrantSmith Thank you for your advice. I tried the code, but it worked as below.
2022/4/12 --> 2022/4/19
2022/4/21 --> 2022/4/10
I want to write code so that if a date other than the 1st come in, it will still be the 1st as below.
2022/4/12 --> 2022/4/1
2022/4/21 --> 2022/4/1
Thank you.
0
Categories
- 10.8K All Categories
- 3 Private Company Board
- 1 APAC User Group
- 12 Welcome
- 39 Domo News
- 9.7K Using Domo
- 1.9K Dataflows
- 2.5K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 343 Workbench
- 260 Domo Best Practices
- 11 Domo Certification
- 464 Domo Developer
- 50 Domo Everywhere
- 105 Apps
- 714 New to Domo
- 85 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 27 お知らせ
- 64 Kowaza
- 299 仲間に相談
- 653 ひらめき共有