SQL request : Can't use function DATE_TRUNC in my request

I wan’t do a request SQL for a dashboard in ForestAdmin that uses DATE_TRUNC in the request SQL but ForestAdmin gives me this error : FUNCTION database.DATE_TRUNC does not exist ?

Why I have the error ? This function is used in the example : https://docs.forestadmin.com/documentation/reference-guide/charts/analytics

Hi @Cedric_des_Lauriers,

Thanks for reaching out :slight_smile:

Did you try to apply this SQL request directly on your database (not from Forest Admin)?
Does it work?