3 Replies Latest reply: Jun 9, 2011 5:31 PM by Joe Kirwan RSS

    Setting default date selection on load

    Joe Kirwan

      Hi

       

      I have a sheet with various tables and charts with a List Box containing all Dates from a date field (DATE) in one of my loaded tables.

       

      I use the list box to select dates for the table / chart displays.

       

      How can I arrange so that the latest date in the date field is automatically selected upon opening the file.

       

      I have checked the forums and tried setting a trigger On Open>Actions>Select in Field with Field = DATE and Search String = =date(Max(DATE))

       

      It does not work.

       

      Thanks