Parameter/Formula Question

[jayster7]

I have a report reading a table containing a credential date field {table.credate}. I want to allow the user to enter a date range as a parameter and then have the report caluclate the date range minus 2 years, ({table.credate}-730) right(?) and give that output. I'm getting a little stuck though in getting output. Any help is appreciated. Thanks!

 

[synapsevampire]

{table.date}-730 is not right, it wouldn't allow for leap years.

Try:

{table.date} > dateadd("y",-2,{?MyParm})

Are you stating that you ONLY want data from the previous 2 years?

If it's a date range, use something like:

Report->Edit Seelction Formula->Record:

{table.date} >= dateadd("y",-2,minimum({?DateParm}))
and
{table.date} <= dateadd("y",-2,maximum({?DateParm}))

If this doen't help, please post meaningful technical information (and on all future posts, you make people guess with little blurbs about requirements like this):

Crystal version
Database/connectivity used
Example data
Expected output

-k

 

[jayster7]

Synapse, apologies for not giving the tech specs. I used the range values that you specifed and it worked like a charm using "yyyy"! Using CR10 accessing .dbf tables from a medical provider database, but it gave exactly what I was looking for, provider records, where their credentialing was 2 years ago from the month the user specified in the parameter. THANK YOU so much!