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 toany 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 toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.0 -
Thank you so much Mark!
0
Categories
- 10.6K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 474 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 478 Datasets
- 214 Visualize
- 259 Beast Mode
- 2.1K Charting
- 12 Variables
- 19 Automate
- 356 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 249 Distribute
- 65 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 190 Product Ideas
- 1.2K Ideas Exchange
- 11 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive