Todays Date

[EscapeUK]

In my select statement i have a date field how do I select items for the current date plus one day, eg tommrow

 

[BradB]

Create a forumla, and put the following code in:
Currentdate+1

Your done!
Bradb

 

[EscapeUK]

oops forgot to say this needs to be in SQL

 

[BradB]

This worked for me in the Cyrstal SQL Designer.

SELECT
eventstb."e_staff",
eventstb."e_staff_name",
eventstb."e_date"
FROM
"dharma"."eventstb" eventstb
WHERE
eventstb."e_date" = ({d '2002-03-01'}+1)

BradB

 

[EscapeUK]

How do I get the current date into where you typed 2002-03-01.

Also forgot to mention it is looking at an oracle DB

 

[BradB]

I checked in the Help file of Crystal SQL Designer and found the CURDATE() Returns the current system date.

The following example works.
SELECT
eventstb."e_staff",
eventstb."e_staff_name",
eventstb."e_date"
FROM
"dharma"."eventstb" eventstb
WHERE
eventstb."e_date" =(CURDATE()+1)

 

[chelseatech]

In Oracle I think the funstion you want is SYSDATE and you can create a SQL expression in CR and use that in your selection formula. Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm