rizerapii

So, what is next? I add %%WHERE%% in the end.

WP_PS.id) >= '2021-04-01' %%WHERE%%
AND       (Select post_date FROM wp_posts WP_PS WHERE 
 WP_PS.Id = WP_WC.order_id GROUP BY WP_PS.id) <= '2021-04-30' %%WHERE%%

or

%%WHERE%% WP_PS.id) >= '2021-04-01' 
AND       (Select post_date FROM wp_posts WP_PS WHERE %%WHERE%%
 WP_PS.Id = WP_WC.order_id GROUP BY WP_PS.id) <= '2021-04-30'

How can use this variable in reports? Can I add my value for example ‘2020-01-01’ – first variable, ‘2021-01-01’ – second variable??