Skip to Content
0

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

Nov 16, 2016 at 02:32 PM

51

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Brian Dong Nov 16, 2016 at 05:24 PM
0

Hi Akshay,

Your formula should look like:

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

Thanks,

Brian

Share
10 |10000 characters needed characters left characters exceeded