I have dBase IV database where is date field and date format is like this: 20.7.1998 (day.month.year).
Then I have Data component and I wanna set components RecordSource property in a runtime. I tryed this but this isn't working.
Data1.RecordSource = "SELECT * FROM " + myDB + " WHERE Date >= #24.7.1998# AND Date <= #24.7.1998#"
Why this isn't working? Could you give me an example?
How I set it if those Dates are variables?
Thanks in advance!