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
MarkShnier__You
Qrew Legend
Qrew LegendTry converting your text result to a date.
Min(
ToDate(Part(ToText([FormulaQuery]),1,";")),
ToDate(Part(ToText([FormulaQuery]),2,";")),
ToDate(Part(ToText([FormulaQuery]),3,";")),
ToDate(Part(ToText([FormulaQuery]),4,";")))
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
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__YouOk, 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
------------------------------