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:
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)