AnsweredAssumed Answered

date calculation

Question asked by AaronRoss on Mar 20, 2012
Latest reply on Mar 20, 2012 by AaronRoss


date calculation



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?