Group: microsoft.public.windows.server.sbs · Group Profile · Search for Ifany in microsoft.public.windows.server.sbs
Author: Joe Letter
Date: Feb 6, 2008 14:00
Is CreationReceived a Date/Time fields, or are you storing dates in a text field? Try IIf(IsNull([TblQCCompletedDates]![CreationReceived]), 0, dhAddWorkDaysA(3,CDate([TblQCCompletedDates]![CreationReceived]),Array(#7/4/2007#,#5/28/2007#)))--Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele(no private e-mails, please)"Supple" <Supple@discussions.microsoft.com> wrote in messagenews:D05FD6D8
|