converting dates in database

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 22145
interpreted = N
texte = I have to convert dates of an old database to their math equivalents.This is my context (without the linebreaks): [replace db=shop_orders.db&neSKUdata=0] OrderDate=[math]{[OrderDate]}[/math] [/replace]The resulting values are the correct numbers of days, but only when I show them on a page. When I use the math tags inside the above replace-context, all dates are set to zero. Why? WebCat Version is 2.1.6 Peter++++++++++++++++++++++++++++++++++++++++++++++++ Peter Ostry - Vienna/Austria - www.ostry.com Fon ++43-1-877 74 54 Fax ++43-1-877 74 54-21 ++++++++++++++++++++++++++++++++++++++++++++++++ Associated Messages, from the most recent to the oldest:

    
  1. converting dates in database (Peter Ostry 1998)
I have to convert dates of an old database to their math equivalents.This is my context (without the linebreaks): [replace db=shop_orders.db&neSKUdata=0] OrderDate=[math]{[OrderDate]}[/math] [/replace]The resulting values are the correct numbers of days, but only when I show them on a page. When I use the math tags inside the above replace-context, all dates are set to zero. Why? WebCat Version is 2.1.6 Peter++++++++++++++++++++++++++++++++++++++++++++++++ Peter Ostry - Vienna/Austria - www.ostry.com Fon ++43-1-877 74 54 Fax ++43-1-877 74 54-21 ++++++++++++++++++++++++++++++++++++++++++++++++ Peter Ostry

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:

grouping fields question (1998) New index for docs (1997) transferring values (1998) question: webmerchant connection (1997) Multiple prices (1997) all records returned. (1997) move files (2000) Unexpected error (1997) RE: Credit card processing - UK (1997) Email notification to one of multiple vendors ? (1997) Anyone using Editize (inline html editor) w/ WebDNA (2003) WebCat 4 Unix/Linux for sale (2003) hidden databases (2000) message board (2001) Store Builder Weirdness (1999) StoreBuilder help/question... (2000) fixed date problem (1997) color and size options (1997) WebCat2 Append problem (B14Macacgi) (1997) Closing Databases (1998)