Filter by 6 week duration, start of the week
Hi - I am interested in filtering data based on time stamp in data between now and 6 weeks, starting from first day of the week (Sunday). This requires additional logic when new year begins. I looked for date time functions and noticed date increment function that would provide 6 weeks in to the future. How can I get start date that is 6 weeks into the past? Thanks!