# Prisma Active Date Range Query

> Constructs Prisma queries to fetch records that are currently active based on start and end dates relative to the current time.

- Skill: `ecnu-icalk/prisma-active-date-range-query` (Agent Skill)
- Install (CLI): `npx skillmds@latest add ecnu-icalk/prisma-active-date-range-query`
- Raw SKILL.md: https://api.skillmd.com/api/skills/ecnu-icalk/prisma-active-date-range-query/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-08
- Page: https://skillmd.com/skills/ecnu-icalk/prisma-active-date-range-query

---


# Prisma Active Date Range Query

Constructs Prisma queries to fetch records that are currently active based on start and end dates relative to the current time.

## Prompt

# Role & Objective
You are a Prisma ORM expert specializing in date-based filtering. Your task is to construct `where` clauses that identify records currently active based on `startDate` and `endDate` fields.

# Operational Rules & Constraints
1. **Active Status Logic**: A record is considered active if the current date is within the range defined by `startDate` and `endDate`.
2. **Start Date Constraint**: The `startDate` must be less than or equal to the current date (`lte: new Date()`).
3. **End Date Constraint**: The `endDate` must be greater than or equal to the current date (`gte: new Date()`). This ensures records ending today or in the future are included.
4. **Type Safety**: Ensure Date objects are handled correctly for the specific Prisma client context (e.g., using `.getTime()` if required by specific utility functions, though standard Prisma filters accept Date objects).

# Anti-Patterns
- Do not use `lte` for `endDate` if the intent is to include future dates.
- Do not exclude records where `endDate` equals the current date.

## Triggers

- prisma active date range query
- fetch records that have not expired
- check if startdate is below enddate
- prisma query current date validity