i am developing a windows application, my database is in MS-Access. I have made a crystal report which is showing product name, activation date, expiry date and days left columns. I want to add one more formula field which will show the status like Running and Expired. If the days are left then it will show running and if the days are not left then it will show expired in that column.
I have made a formula field Days Left, which is showing the days left for the expiry, its working fine but now i want that it will also show the negative days. Like if the product gets expired then the days left field will show the negative dates and the status field will display the status as expired . The code what i have written for formula field days left is:
DateDiff ("d", {tblwarranty.warrantyExpiry} , CurrentDate )
Please help me out with the solution. Please give the code also.