Re: [WebDNA] Convert Math Date in Excel
This WebDNA talk-list message is from 2010
It keeps the original formatting.
numero = 105803
interpreted = N
texte = 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. To see how this works, enter a date in Excel then format the cell as a = number. Enter the same date into a WebDNA [math]{[the_date]}[/math] context. The difference is what needs to be subtracted from any WebDNA date = number to get the equivalent Excel date number. Brian Fries BrainScan Software On Sep 20, 2010, at 3:37 PM, Stuart Tremain wrote: > 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
Associated Messages, from the most recent to the oldest:
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. To see how this works, enter a date in Excel then format the cell as a = number. Enter the same date into a WebDNA [math]{[the_date]}[/math] context. The difference is what needs to be subtracted from any WebDNA date = number to get the equivalent Excel date number. Brian Fries BrainScan Software On Sep 20, 2010, at 3:37 PM, Stuart Tremain wrote: > 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
Brian Fries
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:
So what ya working on? (or have you completed?) (2004)
hideif/showif causes error if wrapped around searches (2003)
WebCat2 beta 11 - new prefs ... (1997)
Need help with emailer- 2 issues (1997)
WebCat2b13MacPlugin - nested [xxx] contexts (1997)
How To get Some Help (2003)
problems with 2 tags shakur (1997)
Add htmlarea 3 to SiteBuilder (2004)
Moment of Thanks (1997)
OS X (2000)
Need help with emailer- 2 issues (1997)
credit card authorization question (1997)
[Listfiles] vs Netfinder (1997)
2.1 bugs left over from beta cycle (1998)
Credit card processing - UK (1997)
[WebDNA] png support in webDNA (2011)
PCS Frames (1997)
A little syntax help (1997)
Less than or equal to........ (1997)
[WebDNA] Installing 7.1.702 on CentOS (2012)