Is there a way to create a filter either on a GI or Dashboard widget to show current month Plus five days? I know there is the @month parameter is there a way to add five days to it, so it forecasts five days into the next month?
Solved
Filters concerning Dates
Best answer by BenjaminCrisman
If you made a custom field which would show this projected date in a date format instead of string format then they dates could be compared, but otherwise the issue is comparing a string format field against a date format and CDdate() doesn’t seem to be able to help with this.
+4Hi
Same with any of the relative parameters like @Today.
So it would like like @Month + 5
Thanks for the reply, when doing that that adds current month plus five months. Still trying to find a way to create filter that shows current month + 5 days. so current month November plus 5 days into December.
+4
do you know if this can be added to Dashboard filter by chance, here is what i’m getting. Thank you for your responses.
+4If you made a custom field which would show this projected date in a date format instead of string format then they dates could be compared, but otherwise the issue is comparing a string format field against a date format and CDdate() doesn’t seem to be able to help with this.
Login to the community
No account yet? Create an account
Social Login
Login with your Acumatica accountEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.