Expression inside IF Statement

[#1]

I am having issues with the following if statement:

What am I doing wrong here ? I need to expand: Date(AddMonths(Max(MonthOfService), -13), 'YYYY-MM') on a Dim.

IF(MonthOfService >= $(=Date(AddMonths(Max(MonthOfService), -13), 'YYYY-MM') ),MonthOfService , Null() )

I've also tried:

IF(MonthOfService >= Date(AddMonths(Max(MonthOfService), -13), 'YYYY-MM') ,MonthOfService , Null() )

but no luck.

[ishanbhatt]

Hi Val,

Create variable of Date(AddMonths(Max(MonthOfService), -13), 'YYYY-MM') and use that in Expression. May be that help.

[sunny_talwar]

Try this:

If(MonthOfService >= Date(AddMonths(Max(TOTAL MonthOfService), -13), 'YYYY-MM'), MonthOfService, Null())