To preface I only added in Time columns because I thought it might help along with Dates.
I am writing the last Date and Time a vehicle filled up to a full tank in the vehicles row in its own separate table, then looking up those values when relevant in Users. Similarly I am writing the Date and Time of every transaction that occurs. I want to query the transactions from the specific date AND time that is after the date AND time written in my vehicles table. The query is like so:
The date and time is:
And yet its pulling transactions from 1pm…:
A date/time column
Written as current date/time when transaction is closed
And it is pulling from bigtables
I got it to work, it seems as though the time filter had to just be after not on or after. My guess is that the date column was pulling all transactions for that date and after, so asking time to do the same thing was redundant? Not sure.
yup, that was my gut feeling, just wanted to be sure you weren’t doing something weird like storing the time as a number or a string.
Yep.
“on or after/on or before” will ignore the time, and just consider the date, whereas “before/after” also takes the time into account.
One other thing to be cognisant of is when you add a date/time column and configure it to display time only, that setting is purely for display purposes. The full date and time is still stored as the underlying value. So in this case, you were storing the exact same value in both columns, making your Time column redundant.
1 Like
