I have a [Scheduled Start Date Time] column which is having dates in my application . I have to generate a report based on following requirement in straight chart or table box
1. if no date is selected in master calendar , should consider today date and display records based on [Scheduled Start Date Time] column for next 3 days from today onwards.
2. If a value is selected in master calendar , then display records based on [Scheduled Start Date Time] column for next 3 days from selected day onwards.
for example, if the selected date is 20th april , then it should display all the rows which has [Scheduled Start Date Time] column matching values as 20th , 21st and 22nd april
I need the expression for this this requirement. i have tried but not getting any value. Here Call_Date is selected value of master calendar
=If(IsNull(Call_Date),
if((Date(floor(Timestamp#([Scheduled Start Date Time],'MM/DD/YYYY hh:mm:ss TT')),'MM/DD/YYYY')) <= (Date(Today() + 60,'MM/DD/YYYY'))
and (Date(floor(Timestamp#([Scheduled Start Date Time],'MM/DD/YYYY hh:mm:ss TT')),'MM/DD/YYYY')) >= (Date(Today(),'MM/DD/YYYY')),[Scheduled Start Date Time]),
if((Date(floor(Timestamp#([Scheduled Start Date Time],'MM/DD/YYYY hh:mm:ss TT')),'MM/DD/YYYY')) <= (Date(Call_Date + 60,'MM/DD/YYYY'))
and (Date(floor(Timestamp#([Scheduled Start Date Time],'MM/DD/YYYY hh:mm:ss TT')),'MM/DD/YYYY')) >= (Date(Call_Date,'MM/DD/YYYY')),[Scheduled Start Date Time]))