skills.rest
foxmaster77
foxmaster77COMMUNITY
Explore all skills by this author →
GitHub

thisQuarter

Resolve the current quarter-to-date window into ISO dates and UTC instants.

1|Updated Aug 23, 2026
Search Tags:#reporting#timezone#temporal#utc#date range#quarter to date#qtd
One-click install
npx skills add https://github.com/foxmaster77/12BOT --skill thisquarter-foxmaster77
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: thisQuarter
Source: https://github.com/foxmaster77/12BOT/tree/main/munder-difflin-main/munder-difflin-main/resources/skills/thisQuarter
Command: npx skills add https://github.com/foxmaster77/12BOT --skill thisquarter-foxmaster77

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? Quarter-to-date reporting requires computing the current quarter's start date and today's date correctly, which is error-prone when done by hand across timezones and quarter boundaries. This Skill resolves "thisQuarter" into concrete, ready-to-use date bounds. ## Core Features & Use Cases - Quarter-to-Date Resolution: Returns the current quarter's start date through today as inclusive civil dates (YYYY-MM-DD) in your local timezone. - UTC Instant Output: Provides the same window as a half-open [start, end) range of exact UTC instants for timestamp-based database queries. - Read-Only Operation: Performs no writes and no network calls, making it safe to run before any QTD metrics task. - Use Case: Before pulling "this quarter's" sales figures from a database, run the resolver to get exact start and end timestamps for your SQL WHERE clause instead of computing dates manually. ## Quick Start Ask the AI to resolve this quarter's date range using the thisQuarter skill before running a quarter-to-date metrics query.

Frequently Asked Questions about thisQuarter

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I get the current quarter's date range for a report?▼

Run the bundled resolver with the argument thisQuarter to get the quarter start through today. It returns inclusive civil dates in your local timezone plus exact UTC instants for timestamp-based queries.

How to use quarter-to-date dates in SQL timestamp queries?▼

Use the startUtc and endExclusiveUtc fields from the resolver output as a half-open [start, end) range in your WHERE clause. This avoids boundary errors that inclusive date comparisons can introduce at midnight.

Does the quarter resolver work across different timezones?▼

Yes, the resolver returns civil dates in your local timezone and includes the timezone name in its output. It also provides UTC instants so timestamp queries remain correct regardless of local timezone.

Can I resolve other date ranges besides this quarter?▼

This Skill only resolves thisQuarter. For other windows like last45days or last6months, or arbitrary ranges, use the separate temporal skill referenced in the documentation.

Does resolving the quarter date range modify any data?▼

No, the resolver is strictly read-only with no writes and no network access. It only computes and prints the date range based on the current run time.

Related Skills

Explore More Data & Analytics Skills→
alibabaalibaba
10.8k

sales_analytics

Provides database schema and business logic for sales data analysis queries.

Official
Basic
syncfusionsyncfusion
3

syncfusion-react-daterangepicker

Automate date range selection with presets and event handling in React.

Official
Advanced
cursorcursor
2.6k

what-did-i-get-done

Summarize authored git commits within a user-specified date range.

Official
Intermediate
osaurus-aiosaurus-ai
54

osaurus-time

Convert timezones and calculate dates with deterministic pure functions.

Official
Intermediate