logo

Warning: The forum is now for consultation only. Please use GitHub Discussions to post any questions or comments.


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:49:08 AM(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)
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.

epf  
#2 Posted : Tuesday, February 12, 2019 8:14:41 AM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 1,209
Switzerland

Thanks: 14 times
Was thanked: 205 time(s) in 198 post(s)
Yes, there is not LastDayOfTheMonth keyword in the current version, could be a new feature request.
robintodd  
#3 Posted : Tuesday, February 12, 2019 12:48: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 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.
epf  
#4 Posted : Tuesday, April 2, 2019 3:06:09 PM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 1,209
Switzerland

Thanks: 14 times
Was thanked: 205 time(s) in 198 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...

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.