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 -
2
Categories
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 470 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 194 Visualize
- 253 Beast Mode
- 2.1K Charting
- 11 Variables
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 247 Distribute
- 63 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 174 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive