convert currentdate to YYYYMMDD in crystal

I need to create a record select query in Crystal that will do from 7 days ago to yesterday.
Currentdate -7 to currentdate -1

The issue is that the current_date field is stored as YYYYMMDD in text format.

How can I create a formula that wil allow this to happen?

Who is Participating?
Use a selection rule of...

{table.datefield}>=totext(Currentdate-7, "yyyyMMdd") and {table.datefield}<=totext(Currentdate-1, "yyyyMMdd")
hwassingerAuthor Commented:
Fantastic & Thanks
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.