Sum on the bases of specific column and filter date

[capriconuser]

  i am  trying to sum on the specific field on the specific filter through back-end 

i try this but did not work m

if(sum(ENDORESMENTDATE > '01-01-2018',IPPREMIUM)) AS VALUEEE

hwo i do this 

[Edvin]

Try this:

sum(if(ENDORESMENTDATE>'01-01-2018',IPPREMIUM)) as VALUEEE

If it's not working, check the ENDORSEMENTDATE date format is it actually DD-MM-YYYY

[shiveshsingh]

May be this?

if(ENDORESMENTDATE > '01-01-2018',Sum(IPPREMIUM))