Seal Report Forum
»
General
»
Feature Request
»
Keyword enhancements for restrictions
Rank: Newbie
Groups: Registered
Joined: 5/29/2017(UTC) Posts: 2 Location: OHIO Was thanked: 2 time(s) in 1 post(s)
|
When using Keywords for restrictions (week, month, year, etc) it would be helpful to use a syntax of (Month) - x where 'x' is the number of days to subtract from the keyword. For example on 2/6/2019 (Month)-1 would give ((2/1/2019) - 1) or 1/31/2019. This way the user can specify the values of 1/1/2019 - 1/31/2019 by using Month-1 for one value and (Month)-1 for another value. The number of days ('x') should be able to be variable. For example if you want to set a value to the 7th of every month, you would use (Month-1)+6 to get 1/7/2019.
Also, not sure if this is already possible but would be nice if Month-'y' that 'y' could be any number. For example, If we wanted to use values to get the last 3 months of data, one would use (Month-3) to (Month)-1 to get 11/1/2018 to 1/31/2019.
Thanks for a solid project and I hope these suggestions can help make the product even better.
|
2 users thanked robintodd for this useful post.
|
epf on 2/13/2019(UTC), DGT on 2/25/2019(UTC)
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209 Thanks: 14 times Was thanked: 206 time(s) in 199 post(s)
|
The 5.0 has new keyword features: Date keyword can be used to specify relative date and time for the restriction value. From the chosen keyword, operations +/- are allowed with the following units: Y(Year), S(Semester), Q(Quarter), M(Month), D(Day), h(hour), m(minute), s(second)
e.g. ThisMonth-1D will do the job
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 5/29/2017(UTC) Posts: 2 Location: OHIO Was thanked: 2 time(s) in 1 post(s)
|
|
|
|
|
Seal Report Forum
»
General
»
Feature Request
»
Keyword enhancements for restrictions
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.