Monthly issue metrics #3

	name: Monthly issue metrics
	on:
	workflow_dispatch:
	schedule:
	- cron: '3 2 1 * *'

	permissions:
	issues: write
	pull-requests: read

	jobs:
	build:
	name: issue metrics
	runs-on: ubuntu-latest
	steps:
	- name: Get dates for last month
	shell: bash
	run: \|
	# Calculate the first day of the previous month
	first_day=$(date -d "last month" +%Y-%m-01)

	# Calculate the last day of the previous month
	last_day=$(date -d "$first_day +1 month -1 day" +%Y-%m-%d)

	#Set an environment variable with the date range
	echo "$first_day..$last_day"
	echo "last_month=$first_day..$last_day" >> "$GITHUB_ENV"

	- name: Run issue-metrics tool
	uses: github/issue-metrics@v2
	env:
	GH_TOKEN: ${{ secrets.GITHUB_TOKEN }}
	SEARCH_QUERY: 'repo:cfwheels/cfwheels created:${{ env.last_month }} -reason:"not planned"'

	- name: dump file content
	run: cat ./issue_metrics.md

	- name: Create issue
	uses: peter-evans/create-issue-from-file@v4
	with:
	title: Monthly issue/pull request metrics report
	token: ${{ secrets.GITHUB_TOKEN }}
	content-filepath: ./issue_metrics.md

	- name: Create a new GitHub Discussion
	id: create-discussion
	uses: abirismyname/create-discussion@v1.1.0
	env:
	GH_TOKEN: ${{ secrets.GITHUB_TOKEN }}
	with:
	title: Monthly issue/pull request metrics report for ${{ env.last_month }}
	body-filepath: './issue_metrics.md'
	repository-id: 'MDEwOlJlcG9zaXRvcnkxMjUwMzM1'
	category-id: 'DIC_kwDOABMUH84CO3DG'

Provide feedback