How can you use a relative date filter in the DOMO Campaigns distribution list filter?
For example, in my DOMO campaign distribution list data source I can have a filter for sale_date is greater than or equal to 6/1/2022. However, what language do I use in the distribution list if I want this date filter to be prior month? Or Last 5 days? Or Prior Year, etc...
The following link references that the filter in the distribution list should include the dataset column name (sale_date), the operands and the value of the filter - but does not explain how to make the value relative to the current date.
Any help would be appreciated. Thanks.