Defaulting a multi box date value when opening a document

[triciagdaly]

I would like to default a multi box date value field to the weekstart of this week.  I've looked into using a macro from OnActivateSheet Trigger but unable to get the syntax correct, and thinking there must be an easier way.  Attached is a screen shot of the multi box properties, and a portion of the screen showing the two values.  I'd like to default to the start of this week (07/14/2014) when opening the document.

[#2 · Accepted solution]

Hi Tricia,

You can still add a "Select in Field" trigger to the OnActivateSheet.

Then under Field, type your date fieldname: Inv_RptWeek

and under Search String, type: =Date(WeekStart(Today()), 'M/D/YYYY')

Hope this helps.

[PradeepReddy]

1) While Opening a Document

     Doc Properties-->Triggeres-->OnOpen-->SelectInField

      FieldName : Date_Field

      FieldValue: date(WeekStart(Date_Field))

2) On sheet Activation

    SheetProperties-->Triggers-->OnActivateSheet--->SelectInField

    FieldName : Date_Field

    FieldValue: date(WeekStart(Date_Field))

[triciagdaly]

I tried this and when refreshing or opening the sheet, date is not appearing.

[#5]

Could be a formatting of date issue.

Are your dates within this field formatted same way as provided in the search string ?