4 Replies Latest reply on Mar 20, 2012 2:56 PM by AaronRoss

    date calculation

    AaronRoss

      Title

      date calculation

      Post

       Hello,

      I have two date fields in my table. One is called appt date and the other is called preset date. Appt date is the date we go out to do our sales call, preset is the day before the appt date we call to verify they will be in.

      My question is, is there a calculation that will subtract one day from day appt date once it submitted? You would thing this would be easy, but we dont go out on SAT or SUN, so if the appt is for MON we need to confirm it on FRI. Is there a calculation for this?