How can I replace "is today" in Crystal reports?

Version 1

    In Query and Report designer you can select "Is Today" on a date criteria.  Here's one way you can achieve similar in Crystal reports:


    Create a formula called ToDate this changes a datetime field into a date only field:


    Date({Name of field})


    For example:




    Then within the select expert (Report - Select Expert - Record) select your formula field and then type in a formula:


    {@ToDate} = CurrentDate