What formats do dates need to be in in order to query a range in the database?

ChrisDavis

I need to grab all rows in a database for a week range. I have the first date of the week and the last date of the week. I've tried timestamps, YYYY-MM-DD, and MM/DD/YYYY. All of those return an error: message=Invalid syntax for schema type[date]

It seems like this would be a simple thing, so maybe I'm doing something wrong. Any help would be appreciated.

ChrisDavis

NVM. I think I figured it out. Was a formatting issue.