I think would do this in Witango.
Just giving this a quick thought, my approach would be like this: Get the week number for both timestamps (format=datetime:%w) and then subtract them, if the result is 0, then both days are in the same week and you can just calculate the span (assuming that both are already weekdays). If the result is 1, then they are in consecutive weeks and you just need to calculate the time from the startdate to Saturday 00:00:00 and then from Sunday 23:59:59 (of the next week) to end date and add. If the number is greater than 1, you do the same as if it was 1, but then also add 5 days for every 1 over 1, because the are 5 days in each intervening week. If it’s possible for the dates to be on the weekend already, then you should slide them to the appropriate timestamp first (start to Monday AM and end back to Friday PM) There is no code to compensate for holidays. I’ve always wanted to add that feature, but it’s daunting. Let me know if this helps you get anywhere, there’s still some work to be done to calculate the partial week spans. Robert From: WebDude [mailto:[email protected]] Sent: Saturday, July 14, 2012 2:24 PM To: [email protected] Subject: TeraScript-Talk: date calculations I have 2 timestamps in the db, we can call them starttime and endtime for now. Has anyone ever wrote a down and dirty calculation that doesn't include weekend days (i.e saturady and sunday? Holidays? I would settle for just a weekend day omit for now. I have been farting around with this and ended up with a bunch of code, but I was hoping for something more elegant. In other words, I am trying to return the total time between the 2 dates and the average time between the two dates for the total return. I started by writing direct db actions to the db but it is pretty daunting for me. Going from datetosecs is relatively easy to figuring this out. Trying to omit Saturaday and Sunday gets a bit more complex, especially if you are dealing with hundreds of returns. Witango 2000 for now... no Robert, I don't have the new servers up and running yet. Hopefully soon! ;-) WebDude _____ To unsubscribe from this list, please send an email to [email protected] with "unsubscribe terascript-talk" in the body. ---------------------------------------- To unsubscribe from this list, please send an email to [email protected] with "unsubscribe terascript-talk" in the body.
