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:

WebCatalog2 Feature Feedback (1996) Bug Report, maybe (1997) shortening the cart (1998) method of payment (1997) [showif] not working (2003) WebCat editing, SiteGuard & SiteEdit (1997) Formvariable (2000) Export database record - append to other database (2005) Associative lookup style? + bit more (1997) suffix mapping for NT? (1997) [taxrate] question (1997) Fun with Dates - revisited (1997) WC1.6 to WC2 date formatting -FIXED! (1997) Upgrade to 3.07 problems (2000) WebCatalog Technical Reference (1997) Practice runs ? (1997) Grouping fields problem (1998) View order not right (1997) webcat and OS 8 (1997) WebCat2b13MacPlugIn - more [date] problems (1997)