Skip to main content
Question

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

  • March 24, 2026
  • 1 reply
  • 17 views

Forum|alt.badge.img

Here are the relevant fields
 

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

1 reply

lauraj46
Captain II
Forum|alt.badge.img+9
  • Captain II
  • 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