Dear Community,
Please can you help me with creating a SQL filter regarding dataset ticker.
I have the following columns: ID, Date, Birtday(layout).
The rows are as followed:
CURRENT WEEK–> Row 1: ID: 17, Date: 24-10-2023(Dutch time notation), Jarige:
With following filter i can show current week:WEEK(Datum, 1) = WEEK(CURDATE())
What i want is creating a filter that shows the layout by current date. Its for showing birtsdays layout.
Maybe using a dataset is not the right option. But what i want is that layouts are shown based on current day and that these are shown in the campaign. When current date is equel to date of the birthday of an employee it should be shown in the campaign, when not the normal campaign should loop.
Best Regards,
Tim