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

    Setting default date selection on load

    Joe Kirwan



      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.