How to format datetime scalar in query?

[ryanking1809]

Say I had a query to find all posts before now(), how do I correctly format the DateTime Scalar?

query {
  posts(where: {createdAt: {lt: now()}}) {
    id,
  }
}

Perhaps this is a Nexus, not a Prisma issue?

[ryands17]

Hey @ryanking1809 👋

createdAt will accept arguments for data types that are either a Date or a String.

So you could query for posts in the following manner,

query {
  posts(where: { createdAt: { lt: new Date() } }) {
    id,
  }
}

or you could pass a timestamp value as a String as well.

Let me know if that solves this!

[ryanking1809]

I believe that does the trick, thanks!