List of Months between two dates
Hi All,
I am trying to create a Magic ETL V2.0 that lists the name of the months in between a hire and termination date for employees. I want to create a bar chart of number of employees who are active and terminated within a given months time.
i.e. Hired: 5/1/2022 and Terminated: 8/31/2022.
Months active = May 2022, June 2022, July 2022 and August 2022.
Terminated = September 2022, October 2022, etc.
I have created a list of dates report to join my employee hired and term dates already.
Best Answer
-
If you really wanted to generate the name of the month and year as text in your ETL, you can use the formula tile to do this. Your formula would look like this:
DATE_FORMAT(`ActiveDate`,'%M %Y')
However, if you leave the date as an actual date, in Analyzer, you can use the custom date format option in the field.
https://domo-support.domo.com/s/article/360043429633?language=en_US
If you need help dynamically generating the dates in between the start and end dates, this video will be helpful 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
-
If you really wanted to generate the name of the month and year as text in your ETL, you can use the formula tile to do this. Your formula would look like this:
DATE_FORMAT(`ActiveDate`,'%M %Y')
However, if you leave the date as an actual date, in Analyzer, you can use the custom date format option in the field.
https://domo-support.domo.com/s/article/360043429633?language=en_US
If you need help dynamically generating the dates in between the start and end dates, this video will be helpful 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 -
Thank you so much Mark!
0
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
- 557 Datasets
- 2K Magic ETL
- 3.3K Visualize
- 2.3K Charting
- 571 Beast Mode
- 11 App Studio
- 28 Variables
- 579 Automate
- 141 Apps
- 414 APIs & Domo Developer
- 23 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 352 Distribute
- 92 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
- 88 Community Announcements
- 4.8K Archive