[Solved] [HSQLDB] SQL statement vs Wrong data type

What is the mistake in SQL ?
User community support forum for Apache OpenOffice, LibreOffice and all the OpenOffice.org derivatives
https://user.services.openoffice.org/en/forum/
https://user.services.openoffice.org/en/forum/viewtopic.php?f=20&t=99857
FJCC wrote:Your last image seems to show that EffectiveDate is being passed as the string '10/08/2019' and that is not a valid date format for HSQLDB, if I remember correctly. I think it must have the format 2019-10-08 or maybe 2019-10-08 00:00:00. I see that in your code you try to set the format but the error message suggests that is not working as expected.
' https://stackoverflow.com/questions/13141328/how-do-i-create-a-specific-date-in-hsqldb
' HSQLDB converts the string automatically.
Dim fed As String : fed = Year(ed) & "-" & Month(ed) & "-" & Day(ed)