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:

3.0 [TEXT] variables (1998) Country & Ship-to address & other fields ? (1997) Featured Site (Again) (2000) ShowNext (1997) Logging purchases (1997) Close-to Comparison Code (1998) type 2 errors with ssl server (1997) Extended [ConvertChars] (1997) no [search] with NT (1997) Search returns all, not 20 (1997) [Announce] Newest Commerce Site based on WebCatalog (1997) Still Stumped on ShowNext...HELP! (1997) keep W* in front applescript? (1998) More questions about serial number dishing (1997) sort without the or a (1998) SSL and reg web* (1997) taxrate - off by 1 cent (1997) Appending current [date] to a database (1997) Re2: AAgghh!! Help, please. SSL strikes again. (1997) different show next (1997)