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

[Former Member]

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" ?

[former_member292966]

Hi Akshay,

Your formula should look like:

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

Thanks,

Brian