1 Reply Latest reply on Nov 8, 2010 12:55 PM by raybaudi

    How do I auto-enter a date field incremented by a week on new record creation

    psamelson

      Title

      How do I auto-enter a date field incremented by a week on new record creation

      Post

      I would like to set an auto entry script that will put a date in the date field that is one week later than the date in the last record.

      I would appreciate any help in creating this. The calculation below will not work because it does not know to draw from the latest date extant in the date field FLR_Date;

      Date ( Month ( FLR_Date ) ; Day ( FLR_Date ) + 7 ; Year ( FLR_Date ) )

      Thanks, 

      Peter