"if condition" scripts for page titles when it involves date
I have a question about ‘if condition’ scripts when it involves date. Let me explain more about that. The dashboard I am working on includes different data, each of which has a different time frame. For example, the data range for one data is from 1 Jan 2015 to 31 Dec 2019, while another data includes dates from 1 Feb 2019 to 31 Jul 2020. In the title of the page for each of the Apps related to each of these data I need to specify what time frame the data involves.
In other words, I need to tell the App if a specific variable exists (which means the date is related to specific dat), show the min & max date – something like: if(Len(Trim([specificvariable]))>0, Date(MonthStart(Min(date)),'d MMM yyyy') & ' to ' & Date(Max(date),'d MMM yyyy')). But it doesn’t work.
*I should add that I have included a master calendar in my dashboard and it works well.