Rank: Newbie
Groups: Registered
Joined: 5/29/2017(UTC) Posts: 2 Location: OHIO Was thanked: 2 time(s) in 1 post(s)
|
I'm trying to use the keyword for restrictions. Month-1 gives me the start of the last month. But what if I'm trying to get the first and last date of the previous month? For example, if I run the report on 2/4/2019. I would like to put in keywords that give me dates between 1/1/2019 and 1/31/2019.
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209 Thanks: 14 times Was thanked: 206 time(s) in 199 post(s)
|
Yes, there is not LastDayOfTheMonth keyword in the current version, could be a new feature request.
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 5/29/2017(UTC) Posts: 2 Location: OHIO Was thanked: 2 time(s) in 1 post(s)
|
Thanks for the quick reply. I'll put in a feature request. It makes the most sense to do a calculation after the fact. On 2/6/2019 to set the dates to the 1st and 31st of January you could use Month-1 for one value (1/1/2019) and (Month)-1 for the second value (1/31/2019). This way you could also set a value of the 7th of every month by using (Month)+6. In addition Month-2 should give you 2 months back. Not sure if this works or not, but would be helpful to use for screens where the user wants to see the last 3 months worth of data.
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209 Thanks: 14 times Was thanked: 206 time(s) in 199 post(s)
|
Hi, I am coding this feature for the 5.0, the way to do it is to enhance the keywords by defineing the unit after the number units would be Y,M,D,h,m,s for Year,Month,Day,hour,minute,second
"ThisMonth - 1" (backward compatibility) or "ThisMonth - 1M" will give the first day of the previous month. so "ThisMonth - 1D" will give the last day of the previous month.
Thank you for your feedbacks on this specification...
|
|
|
|
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.