Dialog problems

cinnamon

Hi,
I am very new to FR, in fact I am a 4 Hour old user.
I have succesfully craeted a report accessing data from my Interbase database.

I have added a From Date and To Date selection where I want the data viewed in my report to range from & include the From Date as selected up to and including the To Date as selected.

I would also like the "DateEdit control" to default to the date of the day and not stick to the date that I designed the report on.

Any suggestions for a SQL query?

gordk

in the onactivate event of the dialogform set dateedit date := now or date
paramaterize your query's sql statement
use 2 params
where fieldname >= :p1 and fieldname <= :p2
in the params editor set the type and in the value add the dateedit controls name
ie dateedit1.date