available times?

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 52831
interpreted = N
texte = Ok everyone I am in need of assistance. I have a meeting scheduler that needs to compare submited times to see if they are available. Time is submit as: s_hour - requested start hour s_minutes - requested start minute e_hour - requested end hour e_minutes - requested end minute For comparison sake we use military time so hours are 01-23 We have two fields in the DB for the entered meetings: s_time - start time e_time - end time we put the times together when submitted: [s_hour][s_minute] = 0705 (minutes are in 5 minute intervals) so what we need is this: Scheduled meetings S_TIME - E_TIME 0700 - 0800 1200 - 1300 Requested times 0730 - 0830 - fail 1230 - 1330 - fail 0530 - 1400 - fail - the hard one 0900 - 1100 - pass 1 - 3 should fail, but 4 should be accepted. So how do I compare this data? Thanks, ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: available times? ( "WebDna @" 2003)
  2. Re: available times? ( Tim Robinson 2003)
  3. Re: available times? ( Tim Robinson 2003)
  4. Re: available times? ( "Gary Krockover" 2003)
  5. Re: available times? ( "Gary Krockover" 2003)
  6. Re: available times? ( Donovan 2003)
  7. Re: available times? ( "WebDna @" 2003)
  8. Re: available times? ( "WebDna @" 2003)
  9. Re: available times? ( Donovan 2003)
  10. Re: available times? ( "WebDna @" 2003)
  11. Re: available times? ( "Gary Krockover" 2003)
  12. Re: available times? ( "WebDna @" 2003)
  13. Re: available times? ( Donovan 2003)
  14. Re: available times? ( "WebDna @" 2003)
  15. Re: available times? ( Donovan 2003)
  16. Re: available times? ( "WebDna @" 2003)
  17. Re: available times? ( Tim Robinson 2003)
  18. available times? ( "WebDna @" 2003)
Ok everyone I am in need of assistance. I have a meeting scheduler that needs to compare submited times to see if they are available. Time is submit as: s_hour - requested start hour s_minutes - requested start minute e_hour - requested end hour e_minutes - requested end minute For comparison sake we use military time so hours are 01-23 We have two fields in the DB for the entered meetings: s_time - start time e_time - end time we put the times together when submitted: [s_hour][s_minute] = 0705 (minutes are in 5 minute intervals) so what we need is this: Scheduled meetings S_TIME - E_TIME 0700 - 0800 1200 - 1300 Requested times 0730 - 0830 - fail 1230 - 1330 - fail 0530 - 1400 - fail - the hard one 0900 - 1100 - pass 1 - 3 should fail, but 4 should be accepted. So how do I compare this data? Thanks, ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ "WebDna @"

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

Webcat/Webmerchant part II (1998) Email Formatting and Encryption (1998) Emailer help....! (1997) WebCat2: Items xx to xx shown, etc. (1997) SKU lookup (1997) using WC to create a DB online (2000) Multiple fields on 1 input (1997) Server Load Tester (2000) Nested tags count question (1997) SiteEdit Pro Update Announcement (1997) All of a Sudden Type 2 errors (1999) More Applescript (1997) [WebDNA] Version 8 (2014) Loosing Quantity (2000) Anybody running directory indexer? (1998) pc (1997) UPPERCASE (1997) Bug Report, maybe (1997) [ot] html question (2000) What am I missing (1997)