Date format Problem in scripting

[#1]

hi Everyone,

     I wrote this expression ,i m getting Invalid expression error.Any suggestions would be greatly appreciated

if(Date(Month,'MM-DD-YYYY')>=Date(Max(Month(Month)),'MM-DD-YYYY'),'Yes','N0') as Flag,

PFA

Thanks in Advance

[MarcoWedel]

Hi,

might be the same.

At least the field 'cmdbci_sys_created_on' has to be included in the group by statement.

Depending on the other fields of your table CMDB, you load with '*', it might be even more to include in the group by.

hope this helps

regards

Marco

[#3]

hi,

     i m using Below expression:

    =Sum({$<Date = {"<=$(=MonthEnd(AddMonths(Max(Date),-1)))"}>}Amount)

It is Working fine .when i select on Date field it is fine .

If i use Month(Date) and i select on particular month  it is giving output as 0.

Pls suggest me.

Thanks in Advance

[Anonymous]

ekkada pani chesthunnaru meeru sister

[MarcoWedel]

please close this thread if your question is answered and open new threads for different topics.

thanks

regards

Marco