DBISAM problem with dates (major issue)
Hi,
I have just discovered that using the new version of DBISAM V3 with
ReportBuilder Version 6.03, that in the end-user area, if I try to create
search criteria on a date that it does not accept it in the form
(dd/mm/yyyy). This is sort of understandable as DBISAM V3 and higher
requires the format to be in yyyy-mm-dd (SQL) format. However, when I enter
this dte as the search criteria, adn I have a look at the resultant SQL
statement I dont get the date inserted as follows:
SELECT staff.BirthDate, staff.FullName
FROM "staff.DAT" staff
WHERE ( staff.BirthDate = )
Therefore as it currently stands you cannot filter on date fields. Anyone
come across this? And is there a solution?
Regards
Alex Vasitch
Favour Pty Ltd
I have just discovered that using the new version of DBISAM V3 with
ReportBuilder Version 6.03, that in the end-user area, if I try to create
search criteria on a date that it does not accept it in the form
(dd/mm/yyyy). This is sort of understandable as DBISAM V3 and higher
requires the format to be in yyyy-mm-dd (SQL) format. However, when I enter
this dte as the search criteria, adn I have a look at the resultant SQL
statement I dont get the date inserted as follows:
SELECT staff.BirthDate, staff.FullName
FROM "staff.DAT" staff
WHERE ( staff.BirthDate = )
Therefore as it currently stands you cannot filter on date fields. Anyone
come across this? And is there a solution?
Regards
Alex Vasitch
Favour Pty Ltd
This discussion has been closed.
Comments
daDBISAM.dcu.
Thankyou
Alex