Comparing just the date part while doing a search for

[t_bubble]

I have a table with a date-time field called ship_by. I want to get all elements where ship_by = today. Doing ship_by = Current date time comapres time as well which i dont want.

[luke2]

Kudos to @mebeingken

How to set an input and equal to a current date

Hi @stolzj19, There are a few ways to handle…here’s one: [41%20PM] Because date data types are actually always date AND time we need to select the entire range of time. In the < comparison we set the current date/time to a day forward and then bring it all back to zero’s on the time – this ensures we get everything including the last millisecond of that date. For the >= we are going back to the first millisecond of the current day.

Editor view (note will filter on today’s date July 10th 2019)

Bubble Editor - luke2

[t_bubble]

@luke2

e we need to select the entire range of time. In the < comparison we set the current date/time to a day forward and then bring it all back to zero’s on the time – this ensures we get everything including the last millisecond of that date. For the >= we are going back to the first millisecond of the current day.

Thanks!