I am trying to build a query to add in a new Field; to find:
- The Date the First Shot was Created on a Project
(and then the Final Date)
When I run a Query for Shot; Date Created By:
I get a list of options: date is, date is not, date is before, date is after, etc…
But I don’t see an option for First / Earliest or Last / Latest.
Is there a way to get that?
For example - I get asked: “When did we really start on that show?”
and would like to have a few High Level queries with auto calculated dates