J
JOM
I have the follolowing statement but it only excludes Weekends, i would also
like to exclude the federal Holidays..... How do I do that?
CompOnTime:
IIf([tblTaxDoc]![TaxDocStatus]="Complete",(IIf((([tblTaxDoc]![TaxDocName]="W2")
And
DateDiff("d",[tblBorrower]![RqstDateRcvd],[tblTaxDoc]![TxDocDateRcvd])-DateDiff("ww",[tblBorrower]![RqstDateRcvd],[tblTaxDoc]![TxDocDateRcvd],7)-DateDiff("ww",[tblBorrower]![RqstDateRcvd],[tblTaxDoc]![TxDocDateRcvd],1)<=10)
Or ([tblTaxDoc]![TaxDocName]="1040" And
DateDiff("d",[tblBorrower]![RqstDateRcvd],[tblTaxDoc]![TxDocDateRcvd]-DateDiff("ww",[tblBorrower]![RqstDateRcvd],[tblTaxDoc]![TxDocDateRcvd],7)-DateDiff("ww",[tblBorrower]![RqstDateRcvd],[tblTaxDoc]![TxDocDateRcvd],1))<=2),"OnTime","OutStd")))
like to exclude the federal Holidays..... How do I do that?
CompOnTime:
IIf([tblTaxDoc]![TaxDocStatus]="Complete",(IIf((([tblTaxDoc]![TaxDocName]="W2")
And
DateDiff("d",[tblBorrower]![RqstDateRcvd],[tblTaxDoc]![TxDocDateRcvd])-DateDiff("ww",[tblBorrower]![RqstDateRcvd],[tblTaxDoc]![TxDocDateRcvd],7)-DateDiff("ww",[tblBorrower]![RqstDateRcvd],[tblTaxDoc]![TxDocDateRcvd],1)<=10)
Or ([tblTaxDoc]![TaxDocName]="1040" And
DateDiff("d",[tblBorrower]![RqstDateRcvd],[tblTaxDoc]![TxDocDateRcvd]-DateDiff("ww",[tblBorrower]![RqstDateRcvd],[tblTaxDoc]![TxDocDateRcvd],7)-DateDiff("ww",[tblBorrower]![RqstDateRcvd],[tblTaxDoc]![TxDocDateRcvd],1))<=2),"OnTime","OutStd")))