Metadata card: set next "Start Date" to be previous "End Date" + 1 (without Property Calculator)

Good afternoon,

We have a document class (Duty Roster) that contains multiple duty periods for staff.
Each period has a Start Date and an End Date.

We want to improve usability for Managers creating these periods. Ideally, when a new period is added:

  • Start Date should automatically default to
    End Date of the previous period + 1 day

Example:
Period 1 → 01-Oct to 05-Oct
Period 2 → "Start Date" should default to 06-Oct

Because the length of each period varies, we cannot use a Property Calculator that assumes a fixed number of days.

Is there a way to automatically set the next period’s Start Date based on the previous period’s End Date when the document is created, and preferably without using Property Calculator?

Any suggestions or best practices would be greatly appreciated!

Thank you!

Patrick.

Example:

Parents Reply
  • I’ve noted this as an idea for a future enhancement to metadata card configuration.

    Currently, your alternatives would need to rely on server-side functionality, such as developing a custom vault application, if options like Property Calculator don’t meet your needs as discussed above. We strongly recommend avoiding new VBScript implementations, as Microsoft has announced plans to deprecate them in the coming years.

Children