What is WebDNA
WebDNA and BioType
Download WebDNA
WebDNA resources
What is WebDNA
WebDNA and BioType
Download WebDNA
WebDNA resources
What is WebDNA
WebDNA and BioType
Download WebDNA
WebDNA resources
What is WebDNA
WebDNA and BioType
Download WebDNA
WebDNA resources
what does: =Math to use Date Display Format? do in the config? it is set to =no?On Wed, Dec 16, 2009 at 5:08 PM, =Bob Minor <bob@cybermill.com> =wrote:Works on my =servers, must be a config issue!
On Dec 16, 2009, at 3:58 PM, Dan Strong wrote:
> What is your date format set to in your WebDNA admin? Mine is ="Month/Date/Year (American)"?
>
> -Dan Strong
> http://www.DanStrong.com
>
> On 12/16/2009 1:55 PM, David Bastedo wrote:
>> So when I put that code on my server, I get 3909 as the year. I =have
>> tried it on two different servers, so I am not sure what is =up.
>>
>> -----
>> [math]val=3D1252257406*1[/math] =3D [math date]{01/01/1970} + ={[format
>> days_to_date %m/%d/%Y][format
>> .6d][math]([val]/86400)[/math][/format][/format]}[/math]
>> 1252257406=3D09/06/3909
>>
>> I have deconstructed the original time stamp to:
>>
>>
>> [Math
>> =show=3Df]subTotal=3D[Math]{09/14/2009}[/math]-[Math]{01/01/1970}[/math][/m=ath]
>> total time + days + 1 day - 5 hours
>> =3D[math]([subTotal]*86400)+{06:08:54}+86400-18000[/math]=3D
>> [reaction_published]
>>
>> so technically, if I do this in the reverse, I should get what =I need . . .
>>
>> d.
>>
>>
>>
>>
>>
>>
>> On Wed, Dec 16, 2009 at 4:01 PM, Marc Thompson <mthompson@media.utah.edu
>> <mailto:mthompson@media.utah.edu>&=gt; wrote:
>>
>> Not sure what the "+1" is for from Dan's example =besides adding an extra
>> day? However, I put the code on my server so =you could see it working.
>> http://webapps.utah.edu/test/temp.tpl
>>
>> Seems to work fine on my server, which is =-7DST.
>>
>> You would need to add some more formatting code to =get it in the form
>> you show in your previous post.
>> ie. The timestamp 1252976934 corresponds to =2009/09/14 06:08:54 pm PDT.
>>
>> Marc
>>
>> David Bastedo wrote:
>> > Unfortunately, I get: 09/16/3909 with =the code below:
>> >
>> > I'm trying to work through this . . .
>> >
>> > d.
>> >
>> >
>> > On Wed, Dec 16, 2009 at 11:17 AM, Marc =Thompson
>> > <mthompson@media.utah.edu =<mailto:mthompson@media.utah.edu><=br>>> <mailto:mthompson@media.utah.edu =<mailto:mthompson@media.utah.edu>&=gt;>
>> wrote:
>> >
>> > Here you go:
>> >
>> > [math]val=3D1252976934*1[/math] ==3D [math date]{01/01/1970} +
>> {[format
>> > days_to_date =%m/%d/%Y][format
>> > =.6d][math]([val]/86400)+1[/math][/format][/format]}[/math]
>> >
>> > Marc
>> >
>> > David Bastedo wrote:
>> > > The timestamp *1252976934* corresponds =to* 2009/09/14 06:08:54 pm
>> > PDT*.
>> > >
>> > > this is the time stamp: =*1252976934*
>> > >
>> > > [format days_to_date =%m/%d/%Y][format
>> > > =.6d][math]([your_UNIX_timestamp]/86400)+1[/math][/format][/format]
>> > >
>> > > gets me: 09/16/39
>> > >
>> > > d.
>> > >
>> > > On Tue, Dec 15, 2009 at 6:54 PM, Dan =Strong
>> <webdna@danstrong.com =<mailto:webdna@danstrong.com>
>> > <mailto:webdna@danstrong.com =<mailto:webdna@danstrong.com>>
>> > > <mailto:webdna@danstrong.com =<mailto:webdna@danstrong.com>
>> <mailto:webdna@danstrong.com =<mailto:webdna@danstrong.com>>>&=gt; wrote:
>> > >
>> > > Try this:
>> > >
>> > > [format days_to_date =%m/%d/%Y][format
>> > >
>> = .6d][math]([your_UNIX_timestamp]/86400)+1[/math][/format][/format]>> > >
>> > >
>> > >
>> > > On 12/15/2009 3:47 PM, =David Bastedo wrote:
>> > >
>> > > Hi, I need =to convert a date stored in unix format -
>> seconds
>> > > since =Jan
>> > > 01, 1970. =Is there a formula or function that anybody
>> > might have?
>> > >
>> > > I am =pulling in an xml file generated by an external
>> api and
>> > > that =date
>> > > comes in =this format.
>> > >
>> > > thanks.
>> > >
>> > > d.
>> > >
>> > >
>> > > --
>> > > David =Bastedo
what does: =Math to use Date Display Format? do in the config? it is set to =no?On Wed, Dec 16, 2009 at 5:08 PM, =Bob Minor <bob@cybermill.com> =wrote:Works on my =servers, must be a config issue!
On Dec 16, 2009, at 3:58 PM, Dan Strong wrote:
> What is your date format set to in your WebDNA admin? Mine is ="Month/Date/Year (American)"?
>
> -Dan Strong
> http://www.DanStrong.com
>
> On 12/16/2009 1:55 PM, David Bastedo wrote:
>> So when I put that code on my server, I get 3909 as the year. I =have
>> tried it on two different servers, so I am not sure what is =up.
>>
>> -----
>> [math]val=3D1252257406*1[/math] =3D [math date]{01/01/1970} + ={[format
>> days_to_date %m/%d/%Y][format
>> .6d][math]([val]/86400)[/math][/format][/format]}[/math]
>> 1252257406=3D09/06/3909
>>
>> I have deconstructed the original time stamp to:
>>
>>
>> [Math
>> =show=3Df]subTotal=3D[math]{09/14/2009}[/math]-[math]{01/01/1970}[/math][/m=ath]
>> total time + days + 1 day - 5 hours
>> =3D[math]([subTotal]*86400)+{06:08:54}+86400-18000[/math]=3D
>> [reaction_published]
>>
>> so technically, if I do this in the reverse, I should get what =I need . . .
>>
>> d.
>>
>>
>>
>>
>>
>>
>> On Wed, Dec 16, 2009 at 4:01 PM, Marc Thompson <mthompson@media.utah.edu
>> <mailto:mthompson@media.utah.edu>&=gt; wrote:
>>
>> Not sure what the "+1" is for from Dan's example =besides adding an extra
>> day? However, I put the code on my server so =you could see it working.
>> http://webapps.utah.edu/test/temp.tpl
>>
>> Seems to work fine on my server, which is =-7DST.
>>
>> You would need to add some more formatting code to =get it in the form
>> you show in your previous post.
>> ie. The timestamp 1252976934 corresponds to =2009/09/14 06:08:54 pm PDT.
>>
>> Marc
>>
>> David Bastedo wrote:
>> > Unfortunately, I get: 09/16/3909 with =the code below:
>> >
>> > I'm trying to work through this . . .
>> >
>> > d.
>> >
>> >
>> > On Wed, Dec 16, 2009 at 11:17 AM, Marc =Thompson
>> > <mthompson@media.utah.edu =<mailto:mthompson@media.utah.edu><=br>>> <mailto:mthompson@media.utah.edu =<mailto:mthompson@media.utah.edu>&=gt;>
>> wrote:
>> >
>> > Here you go:
>> >
>> > [math]val=3D1252976934*1[/math] ==3D [math date]{01/01/1970} +
>> {[format
>> > days_to_date =%m/%d/%Y][format
>> > =.6d][math]([val]/86400)+1[/math][/format][/format]}[/math]
>> >
>> > Marc
>> >
>> > David Bastedo wrote:
>> > > The timestamp *1252976934* corresponds =to* 2009/09/14 06:08:54 pm
>> > PDT*.
>> > >
>> > > this is the time stamp: =*1252976934*
>> > >
>> > > [format days_to_date =%m/%d/%Y][format
>> > > =.6d][math]([your_UNIX_timestamp]/86400)+1[/math][/format][/format]
>> > >
>> > > gets me: 09/16/39
>> > >
>> > > d.
>> > >
>> > > On Tue, Dec 15, 2009 at 6:54 PM, Dan =Strong
>> <webdna@danstrong.com =<mailto:webdna@danstrong.com>
>> > <mailto:webdna@danstrong.com =<mailto:webdna@danstrong.com>>
>> > > <mailto:webdna@danstrong.com =<mailto:webdna@danstrong.com>
>> <mailto:webdna@danstrong.com =<mailto:webdna@danstrong.com>>>&=gt; wrote:
>> > >
>> > > Try this:
>> > >
>> > > [format days_to_date =%m/%d/%Y][format
>> > >
>> = .6d][math]([your_UNIX_timestamp]/86400)+1[/math][/format][/format]>> > >
>> > >
>> > >
>> > > On 12/15/2009 3:47 PM, =David Bastedo wrote:
>> > >
>> > > Hi, I need =to convert a date stored in unix format -
>> seconds
>> > > since =Jan
>> > > 01, 1970. =Is there a formula or function that anybody
>> > might have?
>> > >
>> > > I am =pulling in an xml file generated by an external
>> api and
>> > > that =date
>> > > comes in =this format.
>> > >
>> > > thanks.
>> > >
>> > > d.
>> > >
>> > >
>> > > --
>> > > David =Bastedo
DOWNLOAD WEBDNA NOW!
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...