minig0d's avatar
minig0d
New Member
9 years ago
Status:
Needs Votes

Query Editor's Today Button to use DateTime.LocalNow () rather than static date

Currently in the Query Editor when you do Date/Time transformations/filters there is that button that says "Today" which inserts a static version of today's date. I don't think I've ever wanted to have that date be static, but rather relative to when the report was run. (Ex. I may want it calculate the duration between "Today" and a date to calculate aging, but I've never used the button because I wanted the date hard coded. I suggest either changing that button or having two side by side buttons that say something like Today (static) and Today (dynamic). The dynamic version would use DateTime.LocalNow () as a basis rather than the static date. (Typically when I need to transform or filter based on a static date, it's off a very specific date that is not today but yet is not one of the named metrics.)

2 Comments

Recent ideas