4 Replies Latest reply on Sep 1, 2014 5:33 PM by BrianChase

    Help with due date calculation

    JaimeHorton

      Title

      Help with due date calculation

      Post

           hey everyone 

           i'm learning the program as we speak so i'm sure ill be here quite a bit 

           thanks in advance for the help 

            

           I'm building a database to help with my job as a concert Production coordinator, i want to include a date countdown that tells me how many days i have left till a show 

           i get close by using the calculation formula in a field 

           ShowDate - Get ( CurrentDate )

           where as the show date is the date of the show 

           this provides me a number of days remaining however it does not update as the dates move on, im thinking i need some sort of loop or something. i'm just now getting into learning scripts 

           any help would be great 

           thanks again 

           JHo