Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
In one of our application. Month is considered as A1,A2..A12. To get the max of month in this format I have been using MaxString(MONTH). Looks like it is not working as expected as the max(MONTH) should be A10 but it is still displaying A9 as the max of month.
Please let me know what function will give the result that I need.
Thanks
Attitude
see the attached file
hope this helps
Hi Sunil
Can you please do everything in the script level instead of using variable.
Thanks
Attitude
Hi All
If month contains A1,A2,A3,A4,A5,A6,A7,A8,A9 and A10. Function should return A10 as the max(month).
Thanks
Attitude
see the attached file
hope it make you haapy