I have a predeined variable “Bucketts” with the following formula that is not populating the data correctly.
= If (<CurrentDate()) Then “Past Due” Else If(>CurrentDate()+180)Then"Future"Else (+" QTR "+)
I am having same $amount in Past due and Currnt Quarter. So I am trying to define a variable that fetches the data from April17,2004 to June17,2004. I am getting syntax error while defining the varible X
.=Sum() Where MonthsBetween(‘4/17/2004’ ,‘6/17/2004’)
( My intention is to get the open order amt for the dates between Apr17 & 6/17, based on custer Request date.
Any tips??
regards,
padmaja
padmaja (BOB member since 2002-09-19)