In order to get the number of days in (for example) 2 years, 2 months and 2 days, you can do one of the following.
1. Assume a year has 365 days & a month has 30 (It doesn't and this will not work correctly for your situation) 2. Use a start date. This is preferable since years, months and days are measures of time. Without 2 reference points (Start and either time or end date), you can't measure correctly. For example, tell me the miles between Chicago and some other city that is unspecified. You can't because to measure something (distance, time, etc), you need 2 points. Start and End (or one of those with the distance between one or the other). If you are good at math, it's like me asking you to find for x in the following problem.. x=y+? See our point? :) Laurie Smith wrote: > No, what I need is for example, when if a user selects > 2 years (from the years dropdown box) 2 months ( 2 days from the months > dropdown box) and 2 days (from the days dropdown box then I need to convert > those values to days and add them up. Then that added value will be used with > another dropdown that the user selects from (1-90)to determine how many days > they have left until their certificate expires. Any suggestions?? Sorry if > this is confusing ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311933 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4