We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Format' is not a recognized built-in function name

Thread ID:





121148 Nov 13,2015 08:00 PM UTC Nov 18,2015 02:26 PM UTC Dashboard Platform 5
Tags: Dashboard Designer
Asked On November 13, 2015 08:00 PM UTC

This error occurs when I try to add a DateTime Field.
At this moment, I'm using only Dashboard Design (No Dashboar Server installed)
Language (pt-br) Portuguese Brazilian

OneDrive error image: Error

win7 32b
SQL 2008 Express


Rajadurai C [Syncfusion]
Replied On November 16, 2015 07:39 AM UTC

Hi Hub,

Thanks for your interest in Syncfusion Products.

Regarding the error, can you please share us the error log file(s) generated under the following location in the machine at your end?

Also, let us know the format of the date column (MM/dd/yyyy,.. etc.) in the bounded data that you tried to drop in.

It will help us to diagnose the issue further at our end and get back to you with a prompt solution sooner.


Replied On November 16, 2015 12:30 PM UTC

Information about problem reported.

Attachment: ErrorLog_13_11_2015_(2)_d8fb976f.rar

Rajadurai C [Syncfusion]
Replied On November 17, 2015 02:57 PM UTC

Hi Hub,

Thanks for sharing details. Regarding the date format, the screenshot that you shared reflects the default date format value that every SQL database user option used to have. Can you please let us know the date column type in your data (datetime or date) and in which format the date value displayed (MM/dd/yyyy or dd/MM/yyyy,..)? It would be helpful to us if you share the data to us to diagnose further at our end and get back to you with a prompt solution.


Replied On November 17, 2015 06:29 PM UTC

I found out the source of problem, althogh the documentation says:

What are the system requirements for hosting the dashboard server?

.NET Framework v4.5 and Microsoft SQL Server 2008+.

I think it's not supported in SQL Server 2008, I've updated to 2012 version and now It's working fine.

Please update this information in main page of the application.

Rajadurai C [Syncfusion]
Replied On November 18, 2015 02:26 PM UTC

Hi Hub,

Thanks for getting this problem to our attention.

The system requirements pointed out is for dashboard server which require SQL Server as prerequisite to setup and maintain user accounts and dashboards.

We will separately add the system requirements for server connection types in Dashboard Designer.

Please let us know if you require further assistance.



This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon