Extension of Relative time syntax

Hi
I am trying to set up a report where I filter for the middle of last month to the middle of this month.
This is currently not possible to do with the current functionality of relative date (to my knowledge).

My suggestion is to add 2 new features to the relative date syntax:

Syntax 1: The Nth date of last month
Where

  • Nth is the date like the 18th
  • Last month is relative to the current timestamp and could also be this month or 2 months ago, etc.

Syntax 2: Nth week of last month begin/end
Where

  • Nth week could be the second week
  • Last month is relative to the current timestamp and could also be this month or 2 months ago, etc.
  • begin/end is used to determine if you only want to get the start or end date of the week.