I did some work in this regard in an app I called Conference Scheduler Lite. The big thing with date and time calculations is understanding that an event scheduled for 08:00 - 10:00 does NOT conflict with one from 10:00 to 12:00. Also, someone staying in a room from the first to the third does NOT conflict with someone staying from the 3rd to the 5th. In other words, times and dates can touch without overlapping. Special case has to be used for this in any SQL queries.
I also recently wrote a time calc function that can give you the difference between two times so that 12:00 to 13:00 produces 1:00. It's not a trivial thing to do. I ended up using the approach of converting values to seconds, doing the math then converting it back to hours:minutes:seconds again. Bob S > On Sep 30, 2015, at 11:35 , Mike Kerner <mikeker...@roadrunner.com> wrote: > > I've been messing around with scheduling events in LC, and have run into a > variety of things that make life harder. Does anybody have a CRON/event > scheduling library for LC before I write the other 60% of one? > > Well, I'm probably simplifying the task - the other 85% of one? > > -- > On the first day, God created the heavens and the Earth > On the second day, God created the oceans. > On the third day, God put the animals on hold for a few hours, > and did a little diving. > And God said, "This is good." > _______________________________________________ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
