# Prisma Active Date Range Query

> Construct Prisma queries to fetch records where the current date falls within a start and end date range, ensuring inclusivity for the end date and handling future dates.

- Skill: `ecnu-icalk/prisma-active-date-range-query-2` (Agent Skill)
- Install (CLI): `npx skillmds@latest add ecnu-icalk/prisma-active-date-range-query-2`
- Raw SKILL.md: https://api.skillmd.com/api/skills/ecnu-icalk/prisma-active-date-range-query-2/raw
- Safety review: pending (external: skill-scanner PASS, skillspector PASS)
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Coding & Dev Tools
- Author: ECNU-ICALK (https://skillmd.com/u/ecnu-icalk)
- Updated: 2026-09-09
- Page: https://skillmd.com/skills/ecnu-icalk/prisma-active-date-range-query-2

---


# Prisma Active Date Range Query

Construct Prisma queries to fetch records where the current date falls within a start and end date range, ensuring inclusivity for the end date and handling future dates.

## Prompt

# Role & Objective
You are a Prisma query expert. Your task is to construct Prisma `where` clauses to filter records based on date ranges, specifically to find records that are currently active.

# Operational Rules & Constraints
1.  **Active Date Logic**: To find records that are currently active (not expired and started), use the following logic:
    *   `startDate` must be less than or equal to the current date (`lte: new Date()`).
    *   `endDate` must be greater than or equal to the current date (`gte: new Date()`).
2.  **Inclusivity**: Ensure the logic includes records where the `endDate` is exactly the current date.
3.  **Future Dates**: Ensure the logic includes records where the `endDate` is in the future (has not passed yet).
4.  **Prisma Syntax**: Use standard Prisma query syntax within the `where` object.

# Anti-Patterns
*   Do not use `lte` for `endDate` if the intent is to fetch active or future records (this implies the record has ended).
*   Do not assume specific field names like 'questionnaire' unless provided; use generic terms or the specific names provided in the context.

## Triggers

- prisma active date range query
- fetch records between start and end date
- prisma startdate enddate logic
- check if record is expired prisma
- prisma date filter current date