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. Regards Stuart Tremain IDFK Web Developments AUSTRALIA webdna@idfk.com.au On 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:

    
  1. Re: [WebDNA] Convert Math Date in Excel (Stuart Tremain 2010)
  2. Re: [WebDNA] Convert Math Date in Excel (Stuart Tremain 2010)
  3. Re: [WebDNA] Convert Math Date in Excel (Brian Fries 2010)
  4. Re: [WebDNA] Convert Math Date in Excel (Stuart Tremain 2010)
  5. Re: [WebDNA] Convert Math Date in Excel (Govinda 2010)
  6. [WebDNA] Convert Math Date in Excel (Stuart Tremain 2010)
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. Regards Stuart Tremain IDFK Web Developments AUSTRALIA webdna@idfk.com.au On 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)