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:
Include a big block of text (1997)
Entry pages (was: WebCatalog MAJOR drawback) (1998)
Summing a field full of numbers ... (1997)
OT: Linux Frustrations (2001)
[WebDNA] Multiple e-mail sending (2011)
Multiple prices (1997)
# fields limited? (1997)
Documentation Feedback (1997)
[ot] table gap help?!? (2001)
[TaxableTotal] - not working with AOL and IE (1997)
Hiding HTML and page breaks (1997)
Ready,Set; Print! (1999)
Help name our technology! (1997)
RE: Jimmy Houssen (1998)
[WebDNA] [WSC] WebDNA Development Summit (2014)
Enhancement Request for WebCatalog-NT (1996)
shipCost formula (1997)
RePost: NAT and the CART (1999)
[cart] (1998)
gateway application timeouts (1998)