Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
If your field DATE is formatted as a correct date (i.e. has an underlying numeric value) you should be able to use =Max(DATE) as the search string in your action.
Hi Johannes
How do I check if my field DATE is formatted as a correxct date?
Hi Johannes
Ignore my last question. Your tip sent me looking in right direction. Correct syntax in this case is:
=DATE(Max( "DATE"))