Reply
 
Thread Tools Display Modes
  #1   Report Post  
macropod
 
Posts: n/a
Default

Hi Bruno,

You could do this with fields, but it would be a lot of work.

Firstly, you can't reference dates in table cells. When you do so Word tries
to do math on them (i.e. dividing the numbers for dates in d/m/y format,
subtracting for dates in d-m-y format and adding for dates in d m y format).
So, to overcome that, you'd have to bookmark each date individually, then
use the bookmark references in your formula.

Secondly, the formula itself would have to test the dates in ISO format
(i.e. yyyymmdd) to do the comparison, then express then result in whatever
format you want.

Thus you'll end up with something like:
{=MAX({BkMrk1 \@ yyyymmdd},{BkMrk2 \@ yyyymmdd},{BkMrk3 \@ yyyymmdd}) \@ "dd
MMMM yyyy"}

Cheers


"Bruno G." wrote in message
...
I have a table column which contains dates. I want to show the largest

date
in a field on another page. I've tried using the formula "= max(bookmark
b:b)", but it shows 0.0.

I'm sure I could do it with a macro, but I really would prefer using a
field... Any suggestions?

Bruno G.




  #2   Report Post  
Bruno G.
 
Posts: n/a
Default Find latest date in column

I have a table column which contains dates. I want to show the largest date
in a field on another page. I've tried using the formula "= max(bookmark
b:b)", but it shows 0.0.

I'm sure I could do it with a macro, but I really would prefer using a
field... Any suggestions?

Bruno G.


  #3   Report Post  
Jezebel
 
Posts: n/a
Default

Actually, it's not so easy. Within the body of the document dates are
*words* not numbers, so unless you've formatted them using ISO 8601
(yyyy-mm-dd), the notion of 'largest' is indeterminate. Word tables are not
spreadsheets.



"Bruno G." wrote in message
...
I have a table column which contains dates. I want to show the largest

date
in a field on another page. I've tried using the formula "= max(bookmark
b:b)", but it shows 0.0.

I'm sure I could do it with a macro, but I really would prefer using a
field... Any suggestions?

Bruno G.




  #4   Report Post  
Bruno G.
 
Posts: n/a
Default

Thanks for your help!

Unfortunatly, I can't rely on user bookmarking the date when they add one to
the table... I guess I'll have to try something with VBA and one of the
document events...

Oh well... thanks anyway!

Bruno

"macropod" wrote in message
...
Hi Bruno,

You could do this with fields, but it would be a lot of work.

Firstly, you can't reference dates in table cells. When you do so Word
tries
to do math on them (i.e. dividing the numbers for dates in d/m/y format,
subtracting for dates in d-m-y format and adding for dates in d m y
format).
So, to overcome that, you'd have to bookmark each date individually, then
use the bookmark references in your formula.

Secondly, the formula itself would have to test the dates in ISO format
(i.e. yyyymmdd) to do the comparison, then express then result in whatever
format you want.

Thus you'll end up with something like:
{=MAX({BkMrk1 \@ yyyymmdd},{BkMrk2 \@ yyyymmdd},{BkMrk3 \@ yyyymmdd}) \@
"dd
MMMM yyyy"}

Cheers


"Bruno G." wrote in message
...
I have a table column which contains dates. I want to show the largest

date
in a field on another page. I've tried using the formula "= max(bookmark
b:b)", but it shows 0.0.

I'm sure I could do it with a macro, but I really would prefer using a
field... Any suggestions?

Bruno G.






Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Find and Replace anomaly BruceM Microsoft Word Help 7 January 18th 05 06:47 PM
Date on letter changes to current date when opened - how to stop. BigSkyG Microsoft Word Help 3 January 13th 05 04:13 PM
Finding Creation Date Chris Microsoft Word Help 2 January 11th 05 05:43 AM
Not your average Word column question - help! John Microsoft Word Help 6 January 11th 05 05:32 AM
inserting a date field for a future date rm Microsoft Word Help 2 January 10th 05 08:18 PM


All times are GMT +1. The time now is 03:29 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"