Date comparison for component chart and tables

1. Create two variables (click on the three lines Icon and then select variable) call them start_date and end_date
2. Create a Button dropdown component. Give it the following name: Start date: <%= start_date%>
3. From the dropdown in the component options select Load Entries.
4. Click on the formula icon next to the black box to open the formula editor
5. In the formula editor write the following formula:

1. Back in the component options select the variable start_date in the drop down next to write to variable. Also untick the box next to Allow multiple selections.
2. Make a copy this component (right click on the click on the component, select copy component, then right click on some empty space on the analysis sheet and click paste)
3. In this copy, change the title to "End date: <%= end_date%> " and change the variable in the drop down next to write to variable to end_date

1. Comparison date 1
2. Comparison date 2

1. Comparison start date 1
2. Comparison end date 1
3. Comparison start date 2
4. Comparison end date 2

Hello Calendra,

I am trying to apply the proposed solution, but am facing a rather strange error, as when i call my variable using TO_TIMESTAMP, an error is returned indicating my variable is actually a FLOAT and not a STRING, which precludes converting it to date.

Would you have any suggestion?

Actually, sometimes all it takes is playing with quote marks:

TO_TIMESTAMP(<%= end_date %>, YYYY/MM/DD)

should be instead:

TO_TIMESTAMP('<%= end_date %>', 'YYYY/MM/DD')

Create two button dropdowns (Start Date and End Date) and create dynamic variables (<%=start_date_Option1%> and <%=end_date_Option1%>)

Load entries by inputting script into dropdown:

TO_STRING ("_CEL_O2C_ACTIVITIES"."EVENTTIME" , FORMAT ( '%Y-%m-%d' ) )

When you want to return the date, input script into the component filter:

FILTER "_CEL_O2C_ACTIVITIES"."EVENTTIME" >= {d '<%=start_date_Option1%>' } AND "_CEL_O2C_ACTIVITIES"."EVENTTIME" <= {d '<%=end_date_Option1%>'};