dynamic changing dates in a table,i want find maxdate in that table macro vbscript?

[#1]

hi,

i am ravi ,

i have a  date table in dates are there in that i want find max date into that table that dates are dynamically changing the values

and select the max date to in a variable after that a want use that variable to some other use,by macro i want the vb script. i have the code like that but it wont work can u pleople check this give me slove it

[marcus_sommer]

Why per macro? You could find your max-date simply by max(date).

- Marcus

[#3]

its my client reqirement.he want in macro only.that y i want it .

[marcus_sommer]

In this case I would calculate the max-date within the gui in a variable and use these variable within the macro:

gui-variable:

vMaxdate = max({< AnyCondition = {'AnyValue'}>} Date)

macro:

maxDate= ActiveDocument.Variables("vMaxdate").GetContent.String

But see: Macros are Bad

- Marcus

[#5]

you are saying macros are but client are asking those only,

thanks marcus for your information

but i want complete macro. please send me

[marcus_sommer]

My suggestion from above is a macro-solution - what speaks against it? What should be done within this app what is the final goal?

- Marcus