CODEWITHSUNDEEP
sqloracle-databasecrystal-reports
Juozas
Juozas

Reputation: 11

Date prompt in Crystal Reports

My task is to create a report with a date prompt.

Table structure is like this:

Name --- Valid_from --- Valid_till
------------------------------------
Smth1 --- 2001-01-01 --- 2003-03-03 
Smth2 --- 2002-02-02 --- 2004-04-04

Person should be promoted to enter one date and report should show records that was valid that day.

Environment: Crystal Reports 2008 and Oracle database.

Upvotes: 1

Views: 781

Answers (1)

dmc
dmc

Reputation: 2684

Given a date parameter named {?DateParameter}, you could set your selection criteria to be something like this:

{?DateParameter} between Valid_from and Valid_till

Upvotes: 2

Related Questions