Skip to Content
avatar image
Former Member

How to check the condition column(date)= sysdate-1 in crystal reports

Hi,

I am creating a crystal report in which I have to check below condition in record selection formula workshop.

There is a column of type date (say party_date).

Now I have to select those records for which party date = sysdate - 1.

something like {party date}=sysdate - 1.

How do I do that in "record selection formula workshop" ?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Nov 16, 2016 at 05:24 PM

    Hi Akshay,

    Your formula should look like:

    {table.party_date} = (CURRENTDATE - 1); 

    Thanks,

    Brian

    Add comment
    10|10000 characters needed characters exceeded