Custom date filter in report (Up to specific date)
Custom date filter in report (Up to specific date)
I am trying to add a date selector to a page to filter through a report as shown in this video.
https://www.youtube.com/watch?v=Otm3_7jJE7A
I want however to make a slight modification. I want to make with the selected date a in between (between today and selected date). However I seem to be unable to pass a between selection as in this doc.
https://help.zoho.com/portal/en/kb/creator/developer-guide/others/url-patterns/articles/functionality-based-urls#To_display_a_record_in_detail_view
<%{
if(param_date == null || input.param_date.isEmpty())
{
input.param_date = zoho.currentdate;
}
%>
<div elName='zc-component' formLinkName='Stateless_Form_Filter' params='zc_Header=false&zc_SuccMsg=Data Added Successfully!&zc_SubmitVal=Submit&zc_ResetVal=Reset&Desired_shipping_date=<%=param_date%>'>Loading Form...</div>
<div elName='zc-component' viewLinkName='Report_To_FIlter' params='zc_Header=true&&zc_Desired_shipping_date=' + zoho.currentdate + '&<%=param_date%>&Desired_shipping_date=58'>Loading View...</div>
<%
}%>