Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find and Replace anomaly | Microsoft Word Help | |||
Date on letter changes to current date when opened - how to stop. | Microsoft Word Help | |||
Finding Creation Date | Microsoft Word Help | |||
Not your average Word column question - help! | Microsoft Word Help | |||
inserting a date field for a future date | Microsoft Word Help |