Another Libra Base Question Closed

Question

Woe is me.

Im going to cry :(

I need to know how to do basic arithmatic with dates in Libre Base queries.

All I want to do is find the number of entries that are present for a specific day + 1.

The code I have to get the count for a day you select works and is:
SELECT COUNT( "ID" ) FROM "Raw data" WHERE "Date" = :Start_Date

But how do I do this for a date 1 day in the future from the selected date please? All my efforts have failed dismally.

... and if you are feeling generous, how do I get 2 results displated from a single query where I get the day you select and the next day on seporate lines please?

Virtual beers and my eternal thanks are on offer for the right answer.
 
I really appreciate thank you messages as a payment for solving issues   :o)

ac3mark · Answer

See if your base will allow this:

...Where "date" =+ :start_date+1
 
It is an attempt.

ac3mark · Answer

What if you set the Date +1 as a variable, then call the query on the variable?  Does base allow that?

Declare tom_date date = date+1
Select * from thetable 
WHERE "date" = tom_date;

Another Libra Base Question

2 responses

Similar discussions

Subscribe To Our Newsletter!