Compare Dates without Time

I have a datepicker component where I have chosen it to be of type: Date. On my MongoDB table, I have a column (EntryDate) that's defined as DateTime. I want to be able to write something like: SELECT * FROM ENTRIES WHERE EntryDate = datePicker1.value. This won't work of course because EntryDate is of type DateTime and datePicker1 is of type Date. I come from a SQL Server background, and in it, I would need to write: SELECT * FROM ENTRIES WHERE CAST(EntryDate as Date) = datePicker1.value. How do I do that in SQL?

@Craig_Madsen Welcome to the forum!
You can use moment to format the datePicker1.value

1 Like