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 = BrianThat works, I am now trying to work out how to do an Excel formula :)RegardsStuart TremainIDFK Web DevelopmentsAUSTRALIAwebdna@idfk.com.auOn 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:
BrianThat works, I am now trying to work out how to do an Excel formula :)RegardsStuart TremainIDFK Web DevelopmentsAUSTRALIAwebdna@idfk.com.auOn 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)