Filter collection by math column date

[nathanaelb]

Sometimes what you see as a timestamp (date-time column) in the data editor is not exactly what you get. The date-time column includes both a date and time, and you might be comparing two values that have the same date but different times.

Two ideas :

1. You could change your date-time columns to a yyyymmdd format and compare those numbers.
2. Make sure the times in the date-time columns are exactly the same, for instance 00:00:00. I’m not sure I would even trust this approach, because you might be able to remove hours, minutes and seconds to get to midnight, but I’m not too sure about milliseconds and beyond. Idea 1 should work.

The following might help:

Guide: Mastering Dates & Times

The Date & Time column contains both a date and time value within one single value. Dates and times can therefore be tricky to understand and to work with. It helps to keep things simple to stay out of trouble. Here are a few tips: Writing dates Avoid writing dates manually. Use a picker instead. If done via import, be weary of the format of the date column in the source. Relations Anytime you create a relation with a date, convert the date to either a string (template column) or a number (…