Creating Reports

[cid]

Ok, I have a database with a field name of detention date. This field stores the most recent detention date in it. So my question is in crystal reports how do I sort it out so It will only print the data if the field "detention date" that has the today's date?

This code says required string...

{Tablename.Field} = Currentdate

And this code just sits there...

CDATE({Tablename.Field}) = CurrentDate

My report is attached as a zip below...
Thank you for all the help

[billyboy]

i tried adding CDate({Table1.MyDateString}) = CurrentDate in my Select Expert and it worked..

Maybe you can do a manual check by creating a formula field that returns true if CDate(detention date) = return date and see what is being returned?

[cid]

So when you used the code it worked. When I used it; it would display the results in descending order. I want it to only diplay the results if it has the current date. So if someone does a print preview then it will only show the current date results.

[cid]

If you take a look at my screenshot(attachment) then you can see on my report the names (Jake Powell and Derek Parr) should not be shown according to the formula. Then only name that should be shown on the report is Nicholas Tallant. If you could please take a look at this it would be help... Thank you