Query Builder GetSqlFromRules format

Question

Hello,

In my implementation of QueryBuilder I would like the date format resulting from `GetSqlFromRules` to be `yyyy-MM-dd`, however even if I set the `Format` property in the `QueryBuilderColumn` I always get the long format e.g. '1/25/2022 12:00:00 AM'. Is there a way to override the default format?

Thanks

Gayathri KarunaiAnandam · Answer

Hi Alessio, 
 
We have validated the reported query at our end and are able to replicate the issue at our end. And we have considered this as a bug at our end. And the fix will be included with our upcoming weekly patch release which is scheduled on 16th February 2022.  Please find the feedback details below. 
  
Feedback: https://www.syncfusion.com/feedback/32228/getsqlfromrules-shows-incorrect-date-format  
  
Regards, 
Gayathri K

BAx · Answer

Ok thank you

Gayathri KarunaiAnandam · Answer

Hi Alessio, 
                
We are glad to announce that our weekly patch release (19.4.0.52) is rolled out. We have included the fix for your issue[Sql Rule shows incorrect format]  in this release. So, we suggest you upgrade our Syncfusion packages to our latest version to resolve this issue in your end. 
 
Feedback:  https://www.syncfusion.com/feedback/32228/getsqlfromrules-shows-incorrect-date-format   
 
Please let us know if you need further assistance on this. 
 
Regards, 
Gayathri K