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.
1 Like
luke2
July 10, 2019, 9:06am
2
Kudos to @mebeingken
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)
1 Like