Home End User
New Blog Posts: Merging Reports - Part 1 and Part 2

DBISAM problem with dates (major issue)

edited November 2002 in End User
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

Comments

  • edited December 2002
    Found the answer, DBISAM users were able to help me. I needed a new
    daDBISAM.dcu.

    Thankyou

    Alex

This discussion has been closed.