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
<=br>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.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 =FriesBrainScan =SoftwareOn 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]The client wants to convert it =in excel to the correct date.Obviously I could build an =export function but this was a quick one off =request.RegardsStuart =TremainIDFK Web =DevelopmentsAUSTRALIAwebdna@idfk.com.auOn 21/09/2010, at 6:03 AM, =Govinda wrote:Hi =StuartAt =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?-GOn Sep =20, 2010, at 1:03 AM, Stuart Tremain =wrote:Hi =Guys Does anyone have a formula to =convert WebDNA Math Date in MS Excel to =dd/mm/yyyy Thanks =:) Regards Stuart =TremainIDFK Web =Developments AUSTRALIAwebdna@idfk.com.au------------ Govinda =blockquote>govinda.webdnatalk@gmail.com---------------------------------------------------------This =message is sent to you because you are subscribed =tothe =mailing list =<talk@webdna.us>. To =unsubscribe, E-mail to: =<talk-leave@webdna.us> archives: =http://mail.webdna.us/list/talk@webdna.usBug Reporting: =support@webdna.us---------------------------------------------------------This message is sent to you because you are subscribed =tothe mailing list =<talk@webdna.us>.To unsubscribe, E-mail to: =<talk-leave@webdna.us>archives: =http://mail.webdna.us/list/talk@webdna.us Bug Reporting: =support@webdna.us---------------------------------------------------------This message is sent to you =because you are subscribed tothe mailing list =<talk@webdna.us>.To =unsubscribe, E-mail to: =<talk-leave@webdna.us>archives: =http://mail.webdna.us/list/talk@webdna.usBug Reporting: =support@webdna.us
------------------------------------=---------------------
This message is sent to you because you are =subscribed to
the mailing list <talk@webdna.us>.
To =unsubscribe, E-mail to: <talk-leave@webdna.us>
archives: =http://mail.webdna.us/list/talk@webdna.us
Bug Reporting: =support@webdna.us
|
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
<=br>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.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 =FriesBrainScan =SoftwareOn 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]The client wants to convert it =in excel to the correct date.Obviously I could build an =export function but this was a quick one off =request.RegardsStuart =TremainIDFK Web =DevelopmentsAUSTRALIAwebdna@idfk.com.auOn 21/09/2010, at 6:03 AM, =Govinda wrote:Hi =StuartAt =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?-GOn Sep =20, 2010, at 1:03 AM, Stuart Tremain =wrote:Hi =Guys Does anyone have a formula to =convert WebDNA Math Date in MS Excel to =dd/mm/yyyy Thanks =:) Regards Stuart =TremainIDFK Web =Developments AUSTRALIAwebdna@idfk.com.au------------ Govinda =blockquote>govinda.webdnatalk@gmail.com---------------------------------------------------------This =message is sent to you because you are subscribed =tothe =mailing list =<talk@webdna.us>. To =unsubscribe, E-mail to: =<talk-leave@webdna.us> archives: =http://mail.webdna.us/list/talk@webdna.usBug Reporting: =support@webdna.us---------------------------------------------------------This message is sent to you because you are subscribed =tothe mailing list =<talk@webdna.us>.To unsubscribe, E-mail to: =<talk-leave@webdna.us>archives: =http://mail.webdna.us/list/talk@webdna.us Bug Reporting: =support@webdna.us---------------------------------------------------------This message is sent to you =because you are subscribed tothe mailing list =<talk@webdna.us>.To =unsubscribe, E-mail to: =<talk-leave@webdna.us>archives: =http://mail.webdna.us/list/talk@webdna.usBug Reporting: =support@webdna.us
------------------------------------=---------------------
This message is sent to you because you are =subscribed to
the mailing list <talk@webdna.us>.
To =unsubscribe, E-mail to: <talk-leave@webdna.us>
archives: =http://mail.webdna.us/list/talk@webdna.us
Bug Reporting: =support@webdna.us
DOWNLOAD WEBDNA NOW!
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...