Re: [WebDNA] Convert Math Date in Excel

This WebDNA talk-list message is from

2010


It keeps the original formatting.
numero = 105804
interpreted = N
texte = Brian That works, I am now trying to work out how to do an Excel formula :) Regards Stuart Tremain IDFK Web Developments AUSTRALIA webdna@idfk.com.au On 21/09/2010, at 9:02 AM, Brian Fries wrote: > In Excel 2008 for Mac, subtract 695421 from the WebDNA date, then = format as a date. I assume it is the same for other versions of Excel, = but can't guarantee it. >=20 > To see how this works, enter a date in Excel then format the cell as a = number. >=20 > Enter the same date into a WebDNA [math]{[the_date]}[/math] context. >=20 > The difference is what needs to be subtracted from any WebDNA date = number to get the equivalent Excel date number. >=20 >=20 > Brian Fries > BrainScan Software >=20 >=20 > On Sep 20, 2010, at 3:37 PM, Stuart Tremain wrote: >=20 >> I have given a client a WebDNA db with dates stored as = [MATH]{[date]}[/MATH] >>=20 >> The client wants to convert it in excel to the correct date. >>=20 >> Obviously I could build an export function but this was a quick one = off request. >>=20 >> Regards >>=20 >> Stuart Tremain >> IDFK Web Developments >> AUSTRALIA >> webdna@idfk.com.au >>=20 >>=20 >>=20 >>=20 >> On 21/09/2010, at 6:03 AM, Govinda wrote: >>=20 >>> 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 >>=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 >=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)
Brian That works, I am now trying to work out how to do an Excel formula :) Regards Stuart Tremain IDFK Web Developments AUSTRALIA webdna@idfk.com.au On 21/09/2010, at 9:02 AM, Brian Fries wrote: > In Excel 2008 for Mac, subtract 695421 from the WebDNA date, then = format as a date. I assume it is the same for other versions of Excel, = but can't guarantee it. >=20 > To see how this works, enter a date in Excel then format the cell as a = number. >=20 > Enter the same date into a WebDNA [math]{[the_date]}[/math] context. >=20 > The difference is what needs to be subtracted from any WebDNA date = number to get the equivalent Excel date number. >=20 >=20 > Brian Fries > BrainScan Software >=20 >=20 > On Sep 20, 2010, at 3:37 PM, Stuart Tremain wrote: >=20 >> I have given a client a WebDNA db with dates stored as = [math]{[date]}[/MATH] >>=20 >> The client wants to convert it in excel to the correct date. >>=20 >> Obviously I could build an export function but this was a quick one = off request. >>=20 >> Regards >>=20 >> Stuart Tremain >> IDFK Web Developments >> AUSTRALIA >> webdna@idfk.com.au >>=20 >>=20 >>=20 >>=20 >> On 21/09/2010, at 6:03 AM, Govinda wrote: >>=20 >>> 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 >>=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 >=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:

WebCat2 - [format thousands] (1997) WebCatalog for Postcards ? (1997) Sort Order on a page search (1997) Adding content advice needed (1998) WebCatalog 3.0 manual in binder (1998) Combining search criteria (2000) Template Security error (1997) List of WebDNA users (2002) WebCatalog for guestbook ? (1997) Database Updates (1997) listfiles sort?! (2005) calculating tax rates, mail order solutions and version 2 (1997) TCPconnect issue (2000) Exclamation point (1997) Listserver problem (1997) errormessages.db (1997) can webcat create directories on NT? (1997) 5.0 Pricing (2003) [shownext] link disappears after first use. Why? - because w/out the formvar, max reset to def (2000) Time formatting in linux (2006)