Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have date filed. If I select one value from date filed. It has to show date range(based on Selection) last 4 weeks and also I want to display date range in Subtitle or footer in in Filter pane
Ex: For example If I select 1/7/2017. It has to date range from 10/6/2017 to 1/7/2017(Last 4 weeks)
Thanks,
Siva
So instead of subtracting one month subtract 28 days?
'Date range from '& date(max(Date(WeekEndingCY))-28)& ' to '&Date(max(Date(WeekEndingCY)))
='Date range from '& date(addMonths(max(Date),-1))& ' to '&Date(max(Date))
Maybe try an expression for the Subtitle something like :
= Date ( Min ( [YourDate] ) ) & ' to ' & Date ( Max ( [YourDate] ) )
Hi Omar,
Thanks for reply. when I am adding the expression like below
'Date range from '& date(addMonths(max(Date(WeekEndingCY)),-1))& ' to '&Date(max(Date(WeekEndingCY)))
Ex: I select date 1/7/2017. So, date range last 4 weeks based on selection.
It has to show 1/7/2017 to 3/6/2017(Last 4 weeks)
Thanks,
Siva
What is it returning?
u can alter it as follow:
='Date range from '& Date(max(Date))& ' to '& Date(max(Date)-28)
It is returning date range from 12/7/2016 to 1/7/2017 when I select date 1/7/2017
But I want If I select date 1/7/2017. date range should show 3/6/2017 to 1/7/2017(last 4 weeks)
Thanks,
Siva
So instead of subtracting one month subtract 28 days?
'Date range from '& date(max(Date(WeekEndingCY))-28)& ' to '&Date(max(Date(WeekEndingCY)))