Date script

[upaliwije]

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

[#2 · Accepted solution]

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