Hi all i have a report which needs to get run from every month 1st-15th and from 16th the report need not to have run
in the filter i had like this
[Reporting View].Open Date/Time(UTC/GMT)] between (cast(_first_of_month(current_date),timestamp)) and (_make_timestamp (extract (year , current_date), extract (month,current_date), extract (day, current_date))).
I heard that we can do from event studio , can anyon eplease help me as i need to run the report from 1st-15th everyday , and need to restrict from 16th
how?
Yep, it sounds like Event Studio is the way to go here. You need to create an event that looks for something like day(current_date) between 1 and 15 and then have your report as the task after that.
Hi ,
Can you please specify the condition we need to giv ein event studio
The cataula requirement is the report has to get run everyday from 1st- 15th date as the data is very huge, thats why we need to split the report like that
i kept the condition as
day(current_date) between 1 and 15
But it not worked, Can anyone please help
QuoteBut it not worked
In what way did it not work?
Hi,
Try using the below
current_date >= _first_of_month(current_date) and current_date < _add_days(_first_of_month(current_date),15) and [ONE] = 1
Create the data item [ONE] with 1 in it.
Schedule the event studio report by day if you want it every day or by week if you want the report only on week days. Let us know if you have any questions.
Good luck
New guy