Default Date in Selection List

[#1]

I have a Date labeled TimePeriod that I am using in a selection list.  I want the default selection to be the most recent date.

I am using this syntax and not sure what I am doing incorrect.  Any guidance would be appreciated.

Tigger

OnActivateSheet

Edit Actions

Action=>Select In Field

Field => TimePeriod

Search => =date(max("TimePeriod"))

Not working!!!

[#2]

use this:

date(max({1}TimePeriod))

[#3]

did u try that.....??

[#4]

i did but it isnt working....

no dates are selected with the page is activated

[#5]

try putting that in the text first...and see what is the format u get.

this format shud be the same as ur date format of  the field TimePeriod.

can u post ur format here ?

[#6]

MM/DD/YYYY

[#7]

=date(max({1}TimePeriod),'MM/DD/YYYY')

[sivarajs]

try this macro

declare vMaxDate=max(TimePeriod)

sub test

    set x= ActiveDocument.GetField("TimePeriod")

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

     x.Select maxDate

end sub

[#9]

That worked! Thank you!

[#10]

gr8....pls mark answered

Cheers!!!