Group: microsoft.public.access.queries · Group Profile · Search for 防犯の Q A No 120 in microsoft.public.access.queries
Author: KARL DEWEY
Date: Apr 8, 2008 15:16
... Q.[CCRScopeInitSigDate] AND Q1.End_Date < Q.End_Date)+1)=120)); -- KARL DEWEY Build a ...> [Formal]=0,GetBusinessDay(DateAdd("d",+120,[CCRScopeInitSigDate])),"0") -- KARL DEWEY Build a ... expression. I want to calculate 120 days ahead and, if that date ...]=4 And [Formal]=0,DateAdd("d",+120,[CCRScopeInitSigDate]),"0") I have successfully used...
|