In your error trace I can see ".DATEFORMAT() is applicable for argument types: (java.lang.String, java.lang.String)" The first argument you are passing to DATEFORMAT is an String and it expects a Date... Just convert your string date to date using, for example, DATE(). Hope I'm not late. Regards, Angel.