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
- All Categories
- 1.4K Product Ideas
- 1.4K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 278 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.7K Transform
- 89 SQL DataFlows
- 556 Datasets
- 2K Magic ETL
- 3.3K Visualize
- 2.3K Charting
- 569 Beast Mode
- 11 App Studio
- 27 Variables
- 578 Automate
- 140 Apps
- 414 APIs & Domo Developer
- 23 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 351 Distribute
- 91 Domo Everywhere
- 258 Scheduled Reports
- 2 Software Integrations
- 92 Manage
- 89 Governance & Security
- 9 Product Release Questions
- Community Forums
- 42 Getting Started
- 28 Community Member Introductions
- 85 Community Announcements
- 4.8K Archive