Expression Error

[rohitians]

Hello everyone I have expression when i reload the script it  shows the following error

Error in expression:

')' expected

I am not able to rectify it,

Please if you finf the error please help.

Error in expression:

')' expected

DIM_ProductBatchMaster:

LOAD

     UPPER(PROD_BATCH) AS [Product Batch Code],

     Fact_Type  AS [Fact Type Code],

     Fact_Type_Desc AS [Fact Type],

     LocCode AS [Batch Location Code],

     Loc_name AS [Batch Location],

Date(floor(MDATE),'DD/MM/YYYY') AS [Manufacturing Date],

Date(floor(EDATE),'DD/MM/YYYY') AS [Expiry Date],

Date(floor(EFFDATE),'DD/MM/YYYY') AS [Effective Date],

If(num(Date(floor(EDATE))-($(vDateForAgeing)))>=1 and num(Date(floor(EDATE))-($(vDateForAgeing)))<=30,'1-30',
if(num(Date(floor(EDATE))-($(vDateForAgeing)))>=31 and num(Date(floor(EDATE))-($(vDateForAgeing)))<=60,'31-60',
if(num(Date(floor(EDATE))-($(vDateForAgeing)))>=61 and num(Date(floor(EDATE))-($(vDateForAgeing)))<=90,'61-90',
if(num(Date(floor(EDATE))-($(vDateForAgeing)))>=91 and num(Date(floor(EDATE))-($(vDateForAgeing)))<=180,'91-180',
if(num(Date(floor(EDATE))-($(vDateForAgeing)))>=181,'181+',
if(num(Date(floor(EDATE))-($(vDateForAgeing)))<1 ,'Expired',
if(IsNull(date(EDATE)) OR Date(EDATE)='','Date NA')))))))  AS InvDaysSelection

vDateForAgeing=

=IF(ISNULL(GetFieldSelections($(vMonthName)))=0 OR ISNULL(GetFieldSelections($(vFinancialYear)))=0,DATE(MAX($(vPostingDate))),DATE(Today()))

Thanks and Regards,

Rohit

[sushil353 · Accepted solution]

Hi,

Try to put your variable value in quotes... since it is date data type..

If(num(Date(floor(EDATE))-('$(vDateForAgeing)'))>=1 and num(Date(floor(EDATE))-('$(vDateForAgeing)'))<=30,'1-30',
if(num(Date(floor(EDATE))-('$(vDateForAgeing)'))>=31 and num(Date(floor(EDATE))-('$(vDateForAgeing)'))<=60,'31-60',
if(num(Date(floor(EDATE))-('$(vDateForAgeing)'))>=61 and num(Date(floor(EDATE))-('$(vDateForAgeing)'))<=90,'61-90',
if(num(Date(floor(EDATE))-('$(vDateForAgeing)'))>=91 and num(Date(floor(EDATE))-('$(vDateForAgeing)'))<=180,'91-180',
if(num(Date(floor(EDATE))-('$(vDateForAgeing)'))>=181,'181+',
if(num(Date(floor(EDATE))-('$(vDateForAgeing)'))<1 ,'Expired',
if(IsNull(date(EDATE)) OR Date(EDATE)='','Date NA')))))))  ASInvDaysSelection

HTH

Sushil

[#3]

I check that your code,

here doesn't show any error.

[rohitians]

Thanks For reply it was showing error..