Skip to main content
Question

Report Date Parameter Can Set Min Max

  • October 17, 2023
  • 6 replies
  • 133 views
S
Freshman I

Hi Everyone, Report Parameter Can Set Today Date Value as Max Date, Can Disable From Tomorrow date, please help me to solve this issue

 

 

Laura03

6 replies

Laura03
Captain II
Forum|alt.badge.img+19
  • Laura03
  • Captain II
  • October 17, 2023

Hello,

I have an idea you can try: Please open above unknown report in Acumatica Report Designer. Click File, Schema Builder, and go to Parameters tab. Click on the Date Parameter and click [...] to see Expression Editor.

Add Code like, Less than or equal @Today .   Save report as New Version.

 

Save report as New Version

Laura

~ Laura Barber, WM Synergy
C
Chris Hackett
C
Semi-Pro I
Forum|alt.badge.img+8
  • ChandraM
  • Semi-Pro I
  • October 17, 2023

Hi @sathish80 Is it possible to share the report to verify the output and suggest.

Thanks

Chandra M
StevenRatner
Varsity I
Forum|alt.badge.img
  • StevenRatner
  • Varsity I
  • October 17, 2023

Hi @sathish80, I agree with @Laura02 solution to at least getting the date to default to @Today for the report perimeters.

Steve - Klear Systems
Chris Hackett
S
Freshman I
  • sathish80
  • Author
  • Freshman I
  • October 18, 2023

I used Date Parameter following screenshots, but I can Select Future Date, @Laura02  is Anything I missout?

S
Freshman I
  • sathish80
  • Author
  • Freshman I
  • October 20, 2023

Hello,

I have an idea you can try: Please open above unknown report in Acumatica Report Designer. Click File, Schema Builder, and go to Parameters tab. Click on the Date Parameter and click [...] to see Expression Editor.

Add Code like, Less than or equal @Today .   Save report as New Version.

 

Save report as New Version

Laura

I can select Future Date any other solution?

 

Chris Hackett
Community Manager
Forum|alt.badge.img
  • Chris Hackett
  • Acumatica Community Manager
  • November 29, 2023

Hi @sathish80 were you able to find a solution? Thank you!

Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.
Terms & ConditionsCookie settingsAccessibility statement
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved