Re: [WebDNA] Convert Math Date in Excel

This WebDNA talk-list message is from

2010


It keeps the original formatting.
numero = 105805
interpreted = N
texte = --Apple-Mail-57--368362583 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii =3DIF(BV2>0,(BV2-695421),"") Where BV2 =3D the WebDNA Date, and then format the column as a date :) Regards Stuart Tremain IDFK Web Developments AUSTRALIA webdna@idfk.com.au On 21/09/2010, at 9:29 AM, Stuart Tremain wrote: > Brian >=20 > That works, I am now trying to work out how to do an Excel formula :) >=20 > Regards >=20 > Stuart Tremain > IDFK Web Developments > AUSTRALIA > webdna@idfk.com.au >=20 >=20 >=20 >=20 > On 21/09/2010, at 9:02 AM, Brian Fries wrote: >=20 >> 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 >=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 --Apple-Mail-57--368362583 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii
=3DIF(BV2>0,(BV2-695421),"")

Where BV2 =3D the WebDNA Date, and then = format the column as a date :)

Regards

Stuart Tremain
IDFK = Web Developments
AUSTRALIA




On 21/09/2010, at 9:29 AM, Stuart Tremain wrote:

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 = 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]

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.

Regards

Stuart = Tremain
IDFK Web = Developments
AUSTRALIA
webdna@idfk.com.au




On 21/09/2010, at 6:03 AM, = Govinda wrote:

Hi = Stuart

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?

-G

On 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 = Tremain
IDFK Web = Developments
AUSTRALIA
webdna@idfk.com.au

------------
Govinda
govinda.webdnatalk@gmail.com




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

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

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

------------------------------------= ---------------------
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

= --Apple-Mail-57--368362583-- 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)
--Apple-Mail-57--368362583 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii =3DIF(BV2>0,(BV2-695421),"") Where BV2 =3D the WebDNA Date, and then format the column as a date :) Regards Stuart Tremain IDFK Web Developments AUSTRALIA webdna@idfk.com.au On 21/09/2010, at 9:29 AM, Stuart Tremain wrote: > Brian >=20 > That works, I am now trying to work out how to do an Excel formula :) >=20 > Regards >=20 > Stuart Tremain > IDFK Web Developments > AUSTRALIA > webdna@idfk.com.au >=20 >=20 >=20 >=20 > On 21/09/2010, at 9:02 AM, Brian Fries wrote: >=20 >> 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 >=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 --Apple-Mail-57--368362583 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii
=3DIF(BV2>0,(BV2-695421),"")

Where BV2 =3D the WebDNA Date, and then = format the column as a date :)

Regards

Stuart Tremain
IDFK = Web Developments
AUSTRALIA




On 21/09/2010, at 9:29 AM, Stuart Tremain wrote:

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 = 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]

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.

Regards

Stuart = Tremain
IDFK Web = Developments
AUSTRALIA
webdna@idfk.com.au




On 21/09/2010, at 6:03 AM, = Govinda wrote:

Hi = Stuart

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?

-G

On 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 = Tremain
IDFK Web = Developments
AUSTRALIA
webdna@idfk.com.au

------------
Govinda
govinda.webdnatalk@gmail.com




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

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

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

------------------------------------= ---------------------
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

= --Apple-Mail-57--368362583-- 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:

WebCat2final1 crashes (1997) Replace context problem ... (1997) Robots fill event log (1997) Site Test Please (2005) [ReturnRaw] and PDFs (2005) [WebDNA] ReturnRaw and binarybody (2013) errormessages.db (1997) Multipart/form-data and video (2005) showif errors (1998) WC2b15 File Corruption (1997) WebCat2b13MacPlugIn - [showif][search][/showif] (1997) E-mailer error codes (1997) Bug or syntax error on my part? (1997) PIXO support (1997) Problems with [Applescript] (1997) Redirect (2003) Help with Repost Data msg from form (1997) GD Spam (2003) [OT] Disable/enable field (2003) [include file] wrong path or syntax when using / referingtoo (2002)