Last7Days Including Today

[carla]

Good Evening,

I have a parameter that allows users to show either "All" records or records for the "Last7Days" meaning Last7Days including today.

I am using the following formula and it seems to be pulling the correct data. Could someone please do a sanity check and tell me if my formula looks correct?

{TABLE_EXTACTCASE.CREATION_TIME} in CurrentDate + 1 to dateadd("d",-7,CurrentDate)

Any help is greatly appreciated!
Best Regards,
Carla Abbott

 

[dgillz]

Your field says "creation time" not date. Is this a date field, a time field, or a datetime field?

Other than this detail, your logic is pretty sound.




Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[carla]

Hi dgillz,

Thanks for your response. Yes, that field is a date time field. Confusing, I know )

Thanks for your help!

Carla

 

[synapsevampire]

I would think that you're not pulling back the right data, check the Database->Show SQL Query.

It should be:

{TABLE_EXTACTCASE.CREATION_TIME} in dateadd("d",-7,CurrentDate) to CurrentDate + 1

There's no "all records" demonstrated here so I ignored that part of your post.

-k