Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have one table and one date field VRU_NewDate. I had to make two date Filter From Date and To Date.
I have created two Resident table and two variable fro that. Below is the script.
Date_From:
Load
Date(Floor([VRU_DateTime Arrived])) as VRU_From_Date
Resident OLA_Service_Desk_VRU;
Date_To:
Load
Date(Floor([VRU_DateTime Arrived])) as VRU_To_Date
Resident OLA_Service_Desk_VRU;
Set v_FromDate = Min(VRU_From_Date);
Set v_ToDate = Max(VRU_To_Date);
Data is coming fine.
However user demands that when he will select any date from From Date filter, To Date filter will be showing Selected Date onward, not all dates.
Could you please help me how to implement this.
Thanks,
Sarif
You can create list box of To Date as below..
IF([To Date] >= [From Date], [To Date])
Hi Manish,
I have already tried this logic. It is showing correct value in List Box. But when I am selecting any date from To Date filter, From Date filter changes to All.
Please suggest.
Sarif
Manish,
This is coming like this:
But data wise it is good.
How to rectify this.
Thanks,
Sarif