Extension of Relative time syntax

Feature Suggestions
,
1

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.
2

Hi @mabr,

The syntax 1 seems to have direct link to your original use case (Filter for the middle of last month to the middle of this month), so it’s understandable.

Could you share about your use case with the Syntax 2?

3

Syntax 2 was simply an alternative way to accomplish the same goal. I would probably just implement syntax 1 to solve my use-case