AnsweredAssumed Answered

Min Date Function

Question asked by MichaelVoccola on Oct 10, 2010
Latest reply on Oct 11, 2010 by MichaelVoccola


Min Date Function


I have created a database to manage events for an AV company. The relationship in questions consists of one event having many components. Each component has a variety of dates, for example, a "Start Date."

On the "Event Overview", I have a "Major Times and Dates" section, that I would like to show data related to the components. For instance, I would like the "Global Start Date" on the "Event Overview" to show the minimum "Start Date" value from the related components.

For one reason or another, I am unsuccessful when using the "Min (Components::Start Date )" function.

I am relatively new to databases and am curious what I am missing. I'm sure you will need more information, please let me know what information you need to help solve this problem.

Thank you in advance!