Re: [WebDNA] Convert Math Date in Excel
This WebDNA talk-list message is from 2010
It keeps the original formatting.
numero = 105802
interpreted = N
texte = I have given a client a WebDNA db with dates stored as =[MATH]{[date]}[/MATH]The client wants to convert it in excel to the correct date.Obviously I could build an export function but this was a quick one off =request.RegardsStuart TremainIDFK Web DevelopmentsAUSTRALIAwebdna@idfk.com.auOn 21/09/2010, at 6:03 AM, Govinda wrote:> Hi Stuart>=20> At least I am not quite sure what you are asking here. Can you =elaborate? As you certainly must know, converting WebDNA date stored as =a 'days since 00/00/0000' into 'dd/mm/yyyy' format, via Webdna, is cake. = Where exactly does MS Excel fit into your Q?>=20> -G>=20> On Sep 20, 2010, at 1:03 AM, Stuart Tremain wrote:>=20>> Hi Guys>>=20>> Does anyone have a formula to convert WebDNA Math Date in MS Excel to =dd/mm/yyyy>>=20>> Thanks :)>>=20>>=20>>=20>> Regards>>=20>> Stuart Tremain>> IDFK Web Developments>> AUSTRALIA>> webdna@idfk.com.au>=20> ------------> Govinda> govinda.webdnatalk@gmail.com>=20>=20>=20>=20> ---------------------------------------------------------> This message is sent to you because you are subscribed to> the mailing list
.> To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us> Bug Reporting: support@webdna.us
Associated Messages, from the most recent to the oldest:
I have given a client a WebDNA db with dates stored as =[math]{[date]}[/MATH]The client wants to convert it in excel to the correct date.Obviously I could build an export function but this was a quick one off =request.RegardsStuart TremainIDFK Web DevelopmentsAUSTRALIAwebdna@idfk.com.auOn 21/09/2010, at 6:03 AM, Govinda wrote:> Hi Stuart>=20> At least I am not quite sure what you are asking here. Can you =elaborate? As you certainly must know, converting WebDNA date stored as =a 'days since 00/00/0000' into 'dd/mm/yyyy' format, via Webdna, is cake. = Where exactly does MS Excel fit into your Q?>=20> -G>=20> On Sep 20, 2010, at 1:03 AM, Stuart Tremain wrote:>=20>> Hi Guys>>=20>> Does anyone have a formula to convert WebDNA Math Date in MS Excel to =dd/mm/yyyy>>=20>> Thanks :)>>=20>>=20>>=20>> Regards>>=20>> Stuart Tremain>> IDFK Web Developments>> AUSTRALIA>> webdna@idfk.com.au>=20> ------------> Govinda> govinda.webdnatalk@gmail.com>=20>=20>=20>=20> ---------------------------------------------------------> This message is sent to you because you are subscribed to> the mailing list .> To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us> Bug Reporting: support@webdna.us
Stuart Tremain
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:
[NT] ie 4.0 required (1997)
WebCat hosting providers? (1997)
convertchars and e-mail (1998)
possible, WebCat2.0 and checkboxes-restated (1997)
[OT] Test - THE ANSWER (2003)
Getting a domain listening on port 443 and port 80? (2003)
Big Databases (1997)
email program problem (1998)
webcat 2.1 new cart fields - please explain more (1998)
Upgrading old WebCat Database Files (1997)
M$loth messes with our sites (again) 2004/02/03 (2004)
Page Expiring again... (2006)
Templates on Unix & CGI on Mac? (1997)
[WebDNA] multi [sendmail] inside [search] (2012)
Performance of this mailserver (2000)
cookies and [returnraw] (1997)
New Lawsuit Alleges Unitedhealth/Pacificare Deceived (2006)
2.0Beta Command Ref (can't find this instruction) (1997)
'does not contain' operator needed ... (1997)
more on my bbs (1997)