logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
robintodd  
#1 Posted : Tuesday, February 12, 2019 12:56:57 PM(UTC)
robintodd

Rank: Newbie

Groups: Registered
Joined: 5/29/2017(UTC)
Posts: 2
United States
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.

thanks 2 users thanked robintodd for this useful post.
epf on 2/13/2019(UTC), DGT on 2/25/2019(UTC)
epf  
#2 Posted : Tuesday, July 23, 2019 1:14:26 PM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 693
Switzerland

Thanks: 12 times
Was thanked: 126 time(s) in 123 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
robintodd  
#3 Posted : Tuesday, July 23, 2019 1:26:16 PM(UTC)
robintodd

Rank: Newbie

Groups: Registered
Joined: 5/29/2017(UTC)
Posts: 2
United States
Location: OHIO

Was thanked: 2 time(s) in 1 post(s)
Thanks so much!
Users browsing this topic
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.