Variable Problem

[rohitians]

Hello,

I have a scenario for Inventory ageing where in am using a variable

vDateForAgeing=

=IF(ISNULL(GetFieldSelections(MonthName))=0 OR ISNULL(GetFieldSelections(FinancialYear))=0,DATE(MAX(PostingDate)),DATE(Today()))

but when i reload it says VDateForAgeing field not found I am not able to find the error.

Please Help

Thanks and Regards,

Rohit Yadav

[nilesh_gangurde]

Hii,

Your syntax should be as mentioned below.

=IF(ISNULL(GetFieldSelections(MonthName)) OR ISNULL(GetFieldSelections(FinancialYear)),

     DATE(MAX(PostingDate)),

     DATE(Today()))

try this one...

-Nilesh

[#3]

hi

try this

=IF(GetFieldSelections(MonthName)=0  OR  GetFieldSelections(FinancialYear)=0,

MAX(DATE(PostingDate)),DATE(Today()))

hope this helps you.

[rohitians]

Really Sorry guys i dint used $ sign in script...

Thanks and Regards