TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Vandana Sardana
NA
54
0
crystal report help
Nov 4 2009 5:11 AM
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.
Reply
Answers (
1
)
how to clear taskbar
how to take automatically backup in last day of week