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:

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)