Prisma

Screenshot 2022-07-19 at 5.39.10 PM.png

Screenshot 2022-07-19 at 5.38.48 PM.png

Screenshot 2022-07-19 at 5.40.06 PM.png

I am attaching my model, query and error screenshot. Can anyone please tell me how to resolve it?

You pass the date as a string while it is required to be a Date object?

I'm not positive here but have you tried
```where: {
  calendar_date: {
    equals: dayjs(new Date()).format("YYYY-MM-DD),
  }
}```

<@UQZ4T6XTR> yeah i know it’s a date object but look at my model I am putting `@db.Date` so it’ll store the date only now if I pass `new Date()`  in query it will include time also so will not match with any record

Screenshot 2022-07-19 at 5.54.57 PM.png

This is my database records for employee_calendar

Your error message quite clearly says "Provided String, expected Date*"

<@UQZ4T6XTR> I know but how can I pass date without time I tried `new Date()` instead of `dayjs(new Date()).format("YYYY-MM-DD")`  in where condition but ended up with no record

cause if you look into database screenshot `calendar_date`  only contains date and new Date() has time in it also

Probably you can just pass new Date(), if not you should be able to do (new Date()).setHours(0,0,0)

Can you pass an unformatted Date to the Table? What would that result be?

<https://www.prisma.io/docs/reference/api-reference/prisma-client-reference#examples-41>
I know you said you tried `equals` . Just saw this and wanted to share

I solved it I am passing it like `new Date(dayjs(new Date()).format("YYYY-MM-DD")`
                                        )`