Customer Statement Report Blank When Using @Today in email template

Hi ​@smuddurthi81 please see below solution:

1. Automation Schedule → Filters tab → Statement Date:

   •  Check "Relative" checkbox

   • Set date picker to @Today or @Today-1

   • Don't use free-text @Today

2. OR set Report Default:

   • Edit Customer Statement report → Parameters → Statement Date Default = =@Today()

3. Email Template:

   • Build Schema → Statement Date → Default Value = =@Today()

   • Validate formula (green check)

Root cause: Automation Schedules reject raw @Today text; need Relative checkbox or report-level defaults

​@smuddurthi81 Can you select the customer statement date in the filter and try?

​@nasir Thank you for the update. I have tried the third approach, but the report is still generated as blank. Also, this requirement is only for a single customer, not for all customers. I believe that modifying the report itself would impact all customers, which we want to avoid.

​@smuddurthi81 I dont think currently date filter will not work for customer statement report.

Modify report as of today filter and send the statement.

​@smuddurthi81 The issue is NOT just @Today— it’s that Automation Schedule is NOT passing parameters correctly to the report &  When parameters fail → report runs with NULL filters → returns blank

In your Email Template → Report Parameters:

🔹 DO THIS:

Instead of: @Today

Use: Statement Date = fixed formula via expression

=Date()

Also Uncheck From Schema

​@Manikanta Dhulipudi Thanks for the update and it’s helpful.

Thanks for the Update ​@smuddurthi81.I’ve tried this steps for another customer.