Skip to main content
Solved

How to implement [ToDate] +1 GI conditional logic in the report

  • March 24, 2026
  • 1 reply
  • 46 views
R
Varsity I
Forum|alt.badge.img

Here are the relevant fields
 

[ToDate] +1 logic doesn’t work on report designer ,Any workaround.

Best answer by lauraj46

Hi ​@rashmikamudalinayake10 ,

Instead of @today, in the Report Designer you can use the formula =Today() in the Default Value field of the FromDate and ToDate parameter definitions.

On the report filters, the parameters are referenced with the '@' sign.  You can specify a formula on the filters by using the Data Field Formula button.  The formula for the end date condition would be:

=DateAdd(@ToDate, 'd', 1)

Hope this helps!

Laura 

 

 

1 reply

lauraj46
Captain II
Forum|alt.badge.img+9
  • lauraj46
  • Captain II
  • Answer
  • March 24, 2026

Hi ​@rashmikamudalinayake10 ,

Instead of @today, in the Report Designer you can use the formula =Today() in the Default Value field of the FromDate and ToDate parameter definitions.

On the report filters, the parameters are referenced with the '@' sign.  You can specify a formula on the filters by using the Data Field Formula button.  The formula for the end date condition would be:

=DateAdd(@ToDate, 'd', 1)

Hope this helps!

Laura 

 

 

Laura - https://www.linkedin.com/in/laura-jaffe-965a411a/ ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
    Terms & ConditionsAccessibility 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