Hi! I want to create a couple of Custom Properties related to the Event Timestamp / Date, namely:
- Day of the week
- Week number (ISO)
I want to use this properties to do some filters, namely:
- get all events from last week (and not necessarily the last 7 days)
- remove events from a particular day of the week
I would also need to know which is the current week number.
How can I achieve such thing? I couldn’t manage to:
- find the event timestamp field while creating a Custom Property
- extract the day of the week or week number from a date ( example: TODAY() )
Thanks in advance!