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
  • Thanks Joonas; a correction from my side since I noticed something in my original post: the intention is that this would be dynamic so the date's would change as they are being updated on the metadata card, in my original post I stated that this should happen "when the document is created" but this was incorrect; it should be dynamic - so I guess using PC and VBScript will achieve what I want.

Children