Re: Problem with formatting dates stored in db
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 52329
interpreted = N
texte = Need a [math]{[gamedate]}[/math]To get you to days -- since you are using days_to_date formatting...On 8/19/03 11:14 AM, "Jesse Crofoot"
wrote:> I've been going through the talk archives trying to find some help on> formatting dates that are stored in a database and haven't had much luck.> I'm trying to format dates stored in the datebase like this 08/19/2003 and> want that date displayed as Tue 08/19. Below are the current Prefernce> Settings in the WebDNA Admin and the code in question. Any help on this> would be greatly appreciated.> > WebDNA - Commerce Edition is running as unix-Cobalt Intel Unix Apache Module> version 4.5.1> > Current WebDNA Preferences:> > Date Display Format: %m/%d/%Y> Read Date Format: Month/Day/year (American)> Math to use Date Display Format?: No> > Code:> > [format days_to_date %a %m/%d][gamedate][/format]> > The [gamedate] variable is stored in the datebase as 08/19/2003> > Output:> > Sun 01/08> > Any assistance on this would be greatly appreciated.> -- Jay Van Vark'Guiding Positive Change in High-Tech Companies'one box voicemail (866) 248-7670 x 6471efax (801) 659-7952http://www.VanVark.net-------------------------------------------------------------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:
Need a [math]{[gamedate]}[/math]To get you to days -- since you are using days_to_date formatting...On 8/19/03 11:14 AM, "Jesse Crofoot" wrote:> I've been going through the talk archives trying to find some help on> formatting dates that are stored in a database and haven't had much luck.> I'm trying to format dates stored in the datebase like this 08/19/2003 and> want that date displayed as Tue 08/19. Below are the current Prefernce> Settings in the WebDNA Admin and the code in question. Any help on this> would be greatly appreciated.> > WebDNA - Commerce Edition is running as unix-Cobalt Intel Unix Apache Module> version 4.5.1> > Current WebDNA Preferences:> > Date Display Format: %m/%d/%Y> Read Date Format: Month/Day/year (American)> Math to use Date Display Format?: No> > Code:> > [format days_to_date %a %m/%d][gamedate][/format]> > The [gamedate] variable is stored in the datebase as 08/19/2003> > Output:> > Sun 01/08> > Any assistance on this would be greatly appreciated.> -- Jay Van Vark'Guiding Positive Change in High-Tech Companies'one box voicemail (866) 248-7670 x 6471efax (801) 659-7952http://www.VanVark.net-------------------------------------------------------------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/
Jay Van Vark
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:
WC Database Format (1997)
WebCAT 3.x (2002)
WebCatalog and directory indexing (1998)
Using copyfolder (2001)
showif and cart (1997)
Listserver problem (1997)
Using [Showif] tag. Mac (1997)
searching multiple databases in single search (1997)
[isfolder] and [filename] (1997)
[OrderFile] being testy (2000)
searching by date (1998)
HTML encoding in URLs (1997)
Hummm .... (1998)
Listfields and foundItems (2002)
Bug alert! (1997)
[WebDNA] Non-numbers entered into a field that asks for a (2008)
AuthorizeNet & StoreBuilder (2002)
# of real domains on 1 web server (1997)
Re:[ShowIf] and empty fields (1997)
Plugin or CGI or both (1997)