[Solved] Query using "today" as a value

[Mountainview]

Hello Forum

My first post so be gentle with me! I'm using version 3.4.1 and the HSQL database engine

I am trying to create a query to collect data for a report that uses the current date, minus a number of days to define the data set.

For example, all records entered in the last 30 days.

I can get todays records without any problem, I'm just having a problem understanding the syntax of subtracting a number of days to create a date "range"

Any help would be appreciated.

Paul

[Sliderule]

Paul:

Welcome to the OpenOffice Base forum.

Per your description, I am assuming you are creating your Query, from the Queries icon on the left, and, under Tasks, Create Query in Design View...

I suggest you use two HSQL database functions:

1. CURRENT_DATE
   
2. DATEDIFF

According to HSQL documentation, found at:

http://www.hsqldb.org/doc/1.8/guide/ch09.html#N1251E

[Mountainview]

Worked first time around, the graphic option was also very good.

Have some future dates (> today) that were simple to remove by changing the:

<=30

To <=30 AND >0

Many thanks

Paul

[Sliderule]

Paul:

Very good.

Just as an additional FYI ( For Your Information ), if you want to make this a DYNAMIC Query . . . that is . . . where the user is Prompted to input the number of days . . . on the Criterion line you enter:

[Mountainview]

Many thanks for the additional information that covers another part of my database that I will be working on soon.

Paul