Wrox Programmer Forums
Go Back   Wrox Programmer Forums > .NET > Other .NET > Crystal Reports
|
Crystal Reports General discussion about Crystal Reports. For discussions specific to the book Professional Crystal Reports for VS.NET, please see the book discussion forum for that book.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Crystal Reports section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old September 29th, 2005, 05:35 AM
Registered User
 
Join Date: Aug 2005
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default Date Difference Help

Hi. Can someone please help me on a date difference formula I wish to write.

This is the scenario: From a contract date field in my sql db I have extracted a date string from an alpha numeric string. This works as needed. Then having got this date string, e.g. 08/2004 (contract start date), I have added one year to this date this which reads as 08/2005 (contract end date).

This tells me that the yearly subscription has expired and needs to be renewed (as we are at the end of September now). Now my problem is how do I write a formula (or even an alert condition) that shows that any particular distributor needs to renew their subscription if one year has passed since the contract start date. The start and end dates are text strings, so how do I convert them to date strings? Please help.






Similar Threads
Thread Thread Starter Forum Replies Last Post
Date difference surya Javascript How-To 2 September 19th, 2008 12:42 AM
get date difference benz_jie2005 Access 1 January 16th, 2008 09:33 AM
Difference between Date and Now() marcin2k Access VBA 3 September 8th, 2005 01:05 PM
Date difference. rupen Classic ASP Basics 6 July 21st, 2005 06:48 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.