1. Home
  2. Forum
  3. Dashboard Platform
  4. 'Format is not a recognized built-in function name...'

'Format is not a recognized built-in function name...'

I'm trying to get a DatePicker using a date time column from my query. The datatype of this column is DateTime however when I try to add this column to the widget I get an error that read: 'FORMAT' is not a recognized built-in function name. Incorrect syntax near 'DashboardSelectSubQuery'. 

How can I resolve this? I am using SQL Server 2008.


Thanks,
Juwon

1 Reply
KM Kavitha Murugesan Syncfusion Team November 23, 2017 07:24 AM UTC

 Hi Juwon, 
 
We have provided the support for SQL Server 2008 from Dashboard Designer v2.3 release itself and it seems your using our older version. We suggest you to upgrade to our Dashboard Designer v2.3 and try the same scenario.  
 
You can download the latest version from the below link. 
 
Regards, 
Kavitha M. 
 


Loader.
Up arrow icon