4 Replies Latest reply: Jul 3, 2013 6:11 AM by George Duckett RSS

    Updating bookmarks selecting an exact value, not as a substring.

    George Duckett

      Updating a bookmark to select todays date.


      I have a trigger on document load that will clear all selected fields, select the current year, month and day and save it as a bookmark, then clear all fields and select the previous working day's year, month and day and replace the bookmark. I leave this selection active so that's what the user gets initially.


      When the document is opened the selection shows fine, however it doesn't work when actually using the bookmarks.


      The year and month work, however for the days selected its selecting 2, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29. It seems to be getting anything starting with a 2, not just 2.


      The formula for selecting todays date is "=Day(Today())"


      It seems like this works when updating what is selected, but as soon as it's saved as a bookmark it breaks.


      How can I fix this issue so that I only select 2 (because today is the second).