Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!!
use this:
date(max({1}TimePeriod))
did u try that.....??
i did but it isnt working....
no dates are selected with the page is activated
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 ?
MM/DD/YYYY
=date(max({1}TimePeriod),'MM/DD/YYYY')
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
That worked! Thank you!
gr8....pls mark answered
Cheers!!!