Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all please help any one in this issue.
May be this:
=Date(MonthEnd(AddMonths(Max(DateField), -1)))
thanks for responding sunny.
sunny, could u please attach any example for regarding this.
Try this in a text box object:
=Date(MonthEnd(AddMonths(Today(), -1))) -> this expression should give you 07/31/2015 (Last day of previous month)
Look at the attached image and the qvw:
good but i need expression for max date of previous fiscal week in set analysis sunny.
Can you share some sample data which is representative of your actual data.