Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
I have a One list box,that list box contains the date field like:
02/18/2015,
02/20/2015,
02/21/2015.
, my requirement is I want to select the max date(02/21/2015) in that date field dynamically through macro(vbscript),how to achieve this,plz help me on this.?
Regrds,
dk.
Actually you can do that without a VBScript Macro ... If you click on the search for the list box and type in
=Max(FieldName) and press enter then you can save a bookmark and in the options when saving select that it should be applied on top of current selections when using the bookmark later....
What is saved in the bookmark is not a snapshot of the max date but the expression you typed in the first place.
So then you have the dynamic search you need - in a bookmark.
Why use a macro when this is easily done with actions?
Hi koti,
you can do this easily using triggers, how do you intend to activate the selection?
Andy