Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
I want to use max function at backend to find the maximum report date coming from multiple bases.
Is it possible?
Ok but due you have the data mapping between the Fiscal Year /Month and the date because the above mapping is not dynamic more like an static approach ? if you define the logic between the Fiscal Year/Month and the date that will help us to get the desired output
Hi Siddharth,
Try using the below expression it is same as what you have already tried , just remove the second max
date(addmonths(Max(Date#(reportdate,'DD-MMM-YYYY')),-1),'DD-MMM-YYYY') as maxdate
your previous expressions would have yielded a the same result but in number instead of date if i am not wrong.
I hope this helps what you want to achieve.