This looks like a syntax error to me. All the examples in the [date processing](https://community.denodo.com/docs/html/browse/6.0/vdp/vql/appendix/syntax_of_condition_functions/date_processing_functions#formatdate) functions for FORMATDATE have the FROM clause included.
Here is a similar example based on the syntax shown in the article:
SELECT dob, formatdate('h:mm a', dob) AS format_date
Without the full query being shown, I am not 100% confident this will solve the problem, but that is the possible syntax error that I can see from **select *,FORMATDATE(‘yyyy-MM-dd’, dob)**.
As an aside, if you have a valid support account, you can submit a case if you wish and the support team can take a deeper look into the error.
Hope this helps!