Max Date

[#1]

Hi All,

I have SalesDate column derived as dual( 'Month End ' &Date(Monthend(Date),'DD-MMM-YYYY'),Date).

I want to show always only one selected SaleDate value. When I open the application it should show max(SalesDate).

How to achieve this?

I am using below.Not working.

[Anonymous]

Hi Jack,

can you explain your problem in detail. Sorry here I am getting it .

Thanks,

[tresB · Accepted solution]

Try search string like:

= 'Month End ' &Date(Monthend(Max({1}Date)),'DD-MMM-YYYY')

[nagarjuna_kotha]

hi,

Try this Below Exoresion :

On Open >> Se;ction Field |>> Search Field:

= 'Month End ' &Date(Monthend(Max(Date)),'DD-MMM-YYYY')

I hope this helps.

-Nagarjun