Re: [firebird-support] Where clause from date field with wrong format

1. Change parameter to be date, not string containing date.2. Reformat it before use in query3. Reformat it in query using cast as date using substringRegards,Karol Bieniaszewski null

[firebird-support] Where clause from date field with wrong format

Hi, I run a SQL with where clause for date field received as a parameter. This parameter has the dd/mm/ format and SQL does not work because it expects dd.mm. format. How can I change the format date for the parameter? Thanks in advance. Jordi