showing maximum of date in a textbox using macro

[Anonymous]

Hi Friends,

I have a Date field in Calendar.I want to show maximum of Date in a text box through macro.

pls help how to do.

regards,

chandan

[brenner_martina]

Hi,

for what do you need a macro? The expression will be:

=Date(Max(datefield),'DD-MM-YYYY')

You can change the value of a variable to show or not to show the textbox!

[Anonymous]

Hi Brenner,

You are right Macro is not required for this purpose.But for learning I want do it using a macro.

thanks,

chandan