Which of the queries below can be used to filter on dates two weeks in the past?

The correct choice for filtering dates two weeks in the past is to start with the current date and subtract two weeks from it. The approach used in the correct answer takes advantage of the marker for the beginning of the current day and subtracts two weeks, calculated with the [%WeekLength%] value, which represents the length of a week in the system.

Using the [%BeginOfCurrentDay%] ensures the calculation focuses on the start of today, providing a consistent reference point. By subtracting two weeks from this reference, you accurately pinpoint a date that is exactly fourteen days earlier.

The other options do not effectively target the desired date range of two weeks back. For instance, subtracting two multiplied by the day length or using the end of the previous week does not align with the two-week criteria when applied to the data points given. Each of those calculations would yield a different date that does not correspond to the two-week past requirement, either by looking at the wrong timeframe or miscalculating the date based on the wrong unit of time.