Date script

upaliwije — Wed, 12 Feb 2014 16:50:43 GMT

sum( {$<[R_YEAR_MONTH]={'>$(=max([R_YEAR_MONTH]))'},POL_TYPE={'F'}>} [PREMIUM] )

my R_YEAR_MONTH=2013-Jan

I want to sum premium where R_YEAR_MONTH>2013-Jan and type ='F'

I have written above expression. It is not working . please help me correct it

Re: Date script

Wed, 12 Feb 2014 17:25:23 GMT

Try to create a second field with Julian format Date converting R_YEAR_MONTH.

and then use this expression with new field

sum( {$<[NEW_FIELD_DATE]={'>$(=max([NEW_FIELD_DATE]))'},POL_TYPE={'F'}>} [PREMIUM] )

Hope this helps