Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try search string like:
= 'Month End ' &Date(Monthend(Max({1}Date)),'DD-MMM-YYYY')
Hi Jack,
can you explain your problem in detail. Sorry here I am getting it .
Thanks,
Try search string like:
= 'Month End ' &Date(Monthend(Max({1}Date)),'DD-MMM-YYYY')
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