Skip to main content
Solved

Filters concerning Dates

  • November 3, 2022
  • 5 replies
  • 716 views
  • Translate All

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? 

Best answer by BenjaminCrisman

@jmeagher I do not believe that this will be able to be used in a dashboard parameter because anywhere except the Conditions tab of the GI will be using a Date schema and not allow expressions like this.

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.

View original

5 replies

BenjaminCrisman
Acumatica Employee
Forum|alt.badge.img+4

Hi @jmeagher! For this you can just add +5 to the expression and it should work.

Same with any of the relative parameters like @Today.

So it would like like @Month + 5

Translate

  • Author
  • Freshman I
  • November 3, 2022

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. 

Translate

BenjaminCrisman
Acumatica Employee
Forum|alt.badge.img+4

@jmeagher Sorry, I misread the request! You can try something like this:
 

 

Translate

  • Author
  • Freshman I
  • November 3, 2022

do you know if this can be added to Dashboard filter by chance, here is what i’m getting.  Thank you for your responses. 

 

 

Translate

BenjaminCrisman
Acumatica Employee
Forum|alt.badge.img+4

@jmeagher I do not believe that this will be able to be used in a dashboard parameter because anywhere except the Conditions tab of the GI will be using a Date schema and not allow expressions like this.

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.

Translate