Min/Max Dates with Formula Queries
I need to use a formula query to find the minimum and maximum date/time for a group of records (Flight Arrival Date/Time) in the same table. I know that there is currently no ability to find the min/m...
Forum Discussion
Thanks for the help, but that's not working. If I keep the field as a Date/Time, then I get "Expecting datetime but found date". But if I change the field to a Date field, I lose the flight arrival time which I need to get the Min.
------------------------------
Michael Frishman
------------------------------
------------------------------
Michael Frishman
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendOk, right. You need to convert to a date time field
https://login.quickbase.com/db/6ewwzuuj?a=dr&rid=143&rl=gyq
The issue is that before you can use the ToTimeStamp function, you need it parse out the date from the time in each Part.
Post back if you need help with thay syntax.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
https://login.quickbase.com/db/6ewwzuuj?a=dr&rid=143&rl=gyq
The issue is that before you can use the ToTimeStamp function, you need it parse out the date from the time in each Part.
Post back if you need help with thay syntax.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------