| Author |  | 
      
        | BeachBum Super User
 
  
  
 Joined: April 11 2007
 Location: United States
 Online Status: Offline
 Posts: 1880
 | 
          How do I use Timed Event Formulas? An example is the 4th of July which is datetime(date(year(today()) + [INCREMENT],7,4),00:00:00). I haven’t figured out how INCREMENT works yet.
           | Posted: July 04 2008 at 08:10 | IP Logged |   |  
           | 
 |  
 __________________
 Pete - X10 Oldie
 | 
       
        | Back to Top |     | 
       
       
        |  | 
        | nadler Super User
 
  
 
 Joined: February 25 2006
 Location: United States
 Online Status: Offline
 Posts: 354
 | 
          It looks like you replace [INCREMENT] with a value.  In the above formula if you replaced [INCREMENT] with a 1 the formula with verify to July 4, 2009.  If  you replaced it with a 2 then it would get you July 4, 2010.  I assume the other timed event formulas work the same way altho I haven't tried them.
           | Posted: July 04 2008 at 13:13 | IP Logged |   |  
           | 
 |  | 
       
        | Back to Top |     | 
       
       
        |  | 
        | BeachBum Super User
 
  
  
 Joined: April 11 2007
 Location: United States
 Online Status: Offline
 Posts: 1880
 | 
          That’s real interesting. I wonder what the intent was or better yet how does this work. Halloween also has a [REFTIME] and that’s a puzzle.
           | Posted: July 04 2008 at 17:23 | IP Logged |   |  
           | 
 |  
 __________________
 Pete - X10 Oldie
 | 
       
        | Back to Top |     | 
       
       
        |  | 
        | jbbtex Senior Member
 
  
 
 Joined: February 15 2007
 Location: United States
 Online Status: Offline
 Posts: 181
 | 
          The Timed Event Formula are used in the Frequency field of a timed event.
           | Posted: July 04 2008 at 22:42 | IP Logged |   |  
           | 
 |  
 You can use them to run macros or whatever on that particular day.
 
 I believe INCREMENT does just that. It increments the year in the July 4 formula so that you can create a timed event that fires each July 4.
 
 You can create Timed Event Formula for birthdays too.
 
 
 
 __________________
 Brady
 
 "Never tell people how to do things. Tell them what to do and they will surprise you with their ingenuity." - Gen. George S. Patton
 | 
       
        | Back to Top |     | 
       
       
        |  | 
        | BeachBum Super User
 
  
  
 Joined: April 11 2007
 Location: United States
 Online Status: Offline
 Posts: 1880
 | 
          So, if I got this right, when I set the Frequency field to July 4th and give it a Raw Formula the formula will execute the next July 4th. I gather INCREMENT is an internal thing.
           | Posted: July 05 2008 at 10:32 | IP Logged |   |  
           | 
 |  
 __________________
 Pete - X10 Oldie
 | 
       
        | Back to Top |     | 
       
       
        |  | 
        | jbbtex Senior Member
 
  
 
 Joined: February 15 2007
 Location: United States
 Online Status: Offline
 Posts: 181
 | 
          That's correct.  But be sure to adjust the reference time.  The default is 00:00:00.
           | Posted: July 05 2008 at 12:37 | IP Logged |   |  
           | 
 |  
 __________________
 Brady
 
 "Never tell people how to do things. Tell them what to do and they will surprise you with their ingenuity." - Gen. George S. Patton
 | 
       
        | Back to Top |     | 
       
       
        |  | 
        | BeachBum Super User
 
  
  
 Joined: April 11 2007
 Location: United States
 Online Status: Offline
 Posts: 1880
 | 
          Thanks for the help Brandy…
           | Posted: July 05 2008 at 12:54 | IP Logged |   |  
           | 
 |   I won’t need to build one for my birthday as yesterday was it and the rest of the nation. 
 __________________
 Pete - X10 Oldie
 | 
       
        | Back to Top |     | 
       
       
        |  | 
        | jbbtex Senior Member
 
  
 
 Joined: February 15 2007
 Location: United States
 Online Status: Offline
 Posts: 181
 | 
          Happy Birthday!
           | Posted: July 05 2008 at 14:48 | IP Logged |   |  
           | 
 |    
 __________________
 Brady
 
 "Never tell people how to do things. Tell them what to do and they will surprise you with their ingenuity." - Gen. George S. Patton
 | 
       
        | Back to Top |     | 
       
       
        |  | 
        | BeachBum Super User
 
  
  
 Joined: April 11 2007
 Location: United States
 Online Status: Offline
 Posts: 1880
 | 
          Must have gotten into the sauce yesterday and was thinking Brandy
           | Posted: July 05 2008 at 14:52 | IP Logged |   |  
           | 
 |   Brady. One year older and still can’t type. Thks again… 
 __________________
 Pete - X10 Oldie
 | 
       
        | Back to Top |     | 
       
       
        |  |