2 Replies Latest reply on Jun 19, 2010 5:18 AM by pmcfee

    Script to add a day

    pmcfee

      Title

      Script to add a day

      Post

      How do you add a new record and it auto adds 1 day from from last record

        • 1. Re: Script to add a day
          raybaudi

          Hi

           

          so now you have a date field, let say that its name is: YourDateField

           

          1) Create a summary field ( name it MaxDate ) = Maximum of YourDateField
          2) Put this calculation into the option of auto-enter a calc for YourDateField :

           

          Case(
          IsEmpty ( Maxdate ) ; Get ( CurrentDate ) ;
          Maxdate + 1
          )

           

          Now every new record will have an incremented date ( if there are no records into the DB, the first record will have the today date )


          • 2. Re: Script to add a day
            pmcfee

            Brilliant once again, thanks, works perfect