Forum Discussion
MarkShnier__You
Qrew Legend
4 years agoTry 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
------------------------------
MichaelFrishma1
4 years agoQrew Trainee
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__You4 years ago
Qrew Legend
Ok, 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
------------------------------