Re: convert a current date into a future date
On Fri, Jun 19, 2009 at 12:35 PM, Nicolas Cueto nicon...@gmail.com wrote: Oh, now I get Kay C Lan's suggestion. Sorry, I often have problems explaining things ;-) ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
convert a current date into a future date
Hello All, I'm looking for a ready-made script/formula for converting a current date into a future date. Of course, it'd need to take into account the number of days in a month, a change in year, and leap years. Centenial or millenial changes can be ignored. Something that, for example, would convert the english date 12/29/09 to 1/5/10, or 2/22/12 to 2/29/12. Trying to save time having to do it myself. Thanks. -- Nicolas Cueto ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: convert a current date into a future date
What is the relationship of the future date to the present one? Are you trying to add a specific number of days to the present date? Paul Looney On Jun 18, 2009, at 7:38 PM, Nicolas Cueto wrote: Hello All, I'm looking for a ready-made script/formula for converting a current date into a future date. Of course, it'd need to take into account the number of days in a month, a change in year, and leap years. Centenial or millenial changes can be ignored. Something that, for example, would convert the english date 12/29/09 to 1/5/10, or 2/22/12 to 2/29/12. Trying to save time having to do it myself. Thanks. -- Nicolas Cueto ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: convert a current date into a future date
How do you mean? You can get the seconds of your future date (and time), the seconds of today's date (and time), subtract, and that will take into account all your issues about leap centuries and such. But what do you want to get out of, or put into, into that function? Craig Newman ** Download the AOL Classifieds Toolbar for local deals at your fingertips. (http://toolbar.aol.com/aolclassifieds/download.html?ncid=emlcntusdown0004) ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: convert a current date into a future date
On Fri, Jun 19, 2009 at 10:38 AM, Nicolas Cueto nicon...@gmail.com wrote: Of course, it'd need to take into account the number of days in a month, a change in year, and leap years. Centenial or millenial changes can be ignored. I think you'll find it's easier than you think. Using dateItems solves all these problems for you, try this in your message box: put the date into startDate convert startDate to dateitems add 1 to item 1 of startDate --year item add 24 to item 2 of startDate --month item add 1095 to item 3 of startDate --day item convert startDate to long date put startDate Basically it adds 1 year to the current date using years, then 2 years using months, then three years using days. You can also use hours ( item 4), minutes (item 5) or seconds (item 6). It doesn't matter, so if you want to know the date and time 3000 hours from now, you can just by adding 3000 to item 4 and Rev will figure out how many days in each of the intervening months and do all the hard work for you :-) If you add 3000 to item 3 (days) Rev will figure out all the leap year stuff for you. Not sure how accurate it is with Centenial and Millenial stuff but if you add 3000 to item 1 it does give an answer. It also automatically figures out the day of the week for you :-) HTH ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: convert a current date into a future date
You know, the whole point is to spend time fooling around. One might say the whole point is to spend enormous quantities of time fooling around. Don't miss that boat. This is a perfect task to learn on. Craig Newman In a message dated 6/18/09 10:38:50 PM, nicon...@gmail.com writes: Trying to save time having to do it myself. ** Download the AOL Classifieds Toolbar for local deals at your fingertips. (http://toolbar.aol.com/aolclassifieds/download.html?ncid=emlcntusdown0004) ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: convert a current date into a future date
What is the relationship of the future date to the present one? Are you trying to add a specific number of days to the present date? Yes. I'm working with the english date. So, given the current date of 6/19/09, what is the date one week from now? two weeks from now? three weeks from now? Tried Kay C Lan's suggestion of converting to dateitems and then adding figures to individual items. But that doesn't automatically step-up to the next month or year. Plus, I really want to avoid thinking about how many seconds in a day, or how many days in each month, or days in a year. Basically, don't want to think at all. Just let Rev do it. -- Nicolas Cueto ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: convert a current date into a future date
Oh, now I get Kay C Lan's suggestion. After adding a figure to a dateitem item, I then simply had to use convert tDate to english date. Thanks. -- Nicolas Cueto ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
