Dates!

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 19238
interpreted = N
texte = Hi folks, I need some advice on the best way to enter dates into a database. I have a customer who wants to set up an event guide with each event having a start_date and End_date. He wants users to be able to click for events on {Today} so WebCat needs to compare {today's date} with the start_date /End_date range. Is mm/dd/yyy the best way to store these dates in the .db? What is the best way to search the .db for {todays} events? Any advice much appreciated:-)Regards, **************************************************************** Micheal O Se www.elive.ie Internet Hosting Service micheal@elive.ie Database powered websites **************************************************************** Associated Messages, from the most recent to the oldest:

    
  1. RE: Dates! (Pat McCormick 1998)
  2. Re: Dates! (Kenneth Grome 1998)
  3. Dates! (Mícheál O Sé 1998)
  4. Re: Dates! (Dave MacLeay 1998)
Hi folks, I need some advice on the best way to enter dates into a database. I have a customer who wants to set up an event guide with each event having a start_date and End_date. He wants users to be able to click for events on {Today} so WebCat needs to compare {today's date} with the start_date /End_date range. Is mm/dd/yyy the best way to store these dates in the .db? What is the best way to search the .db for {todays} events? Any advice much appreciated:-)Regards, **************************************************************** Micheal O Se www.elive.ie Internet Hosting Service micheal@elive.ie Database powered websites **************************************************************** Mícheál O Sé

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:

Re1000001: Setting up shop (1997) 3 card formulas! (1999) WebCat2 beta 11 - new prefs ... (1997) New 4.5 installer (2002) Credit Card Verification.... (1998) Server IP address? (1998) WC 2.0 frames feature (1997) Likelihood of a duplicate (2005) customer.db and forms (1999) Formating found categories (1997) b12 cannot limit records returned and more. (1997) Re:no [search] with NT (1997) LOG IN LOG OUT (1997) Attn: Bug in GeneralStore example b15 (1997) RE: Error: template (1997) Security (1998) Sizes and colors (1999) Help! WebCat2 bug (1997) A little syntax help (1997) New command suggestion (was Modifying databases manually) (1997)