Relative datetime parameter issue--[WeekEnd] does change according to the business date in report

Userlevel 5
Badge +2


      I’ve wrote a report and I’d like it to run on schedule to show the last week’s data.
I was using “[WeekStart]-1” as the datefrom and “[WeekEnd]-1” as the dateto.

       And I save a template to schedule run on every Sunday.

       However, if the business date changes, When using the template the DateFrom would change accordingly, while the dateto would remain still.

       I temporarily work around this issue by assigning

DateTo  =DateAdd( ([@WeekStart]-1), 'd', 6)


        Then, the Dateto would change according to the business date.

        So, I am wondering did someone else meet the same issue and is there anything wrong with the [WeekEnd] parameters.

2 replies

Userlevel 6
Badge +4

Hi Ray,

I just verified the “Week Start” and “Week-End” parameters in the report [2020 R1 version] and populating the values are correct.

Please find the screenshot for reference


Userlevel 5
Badge +2

@Naveen B 
Hello Senior Captain, sorry I did not describe my steps in details. It is working well without template, but it is not working with “Report Template”.
Below are my steps

1,  save a template “1234”, when business date is today, the date from and date to is correct


2, Let’s change the business date to next week to pretend we have moved to next week.

At that time, what I expectation is to search this week’s data


You see, the datefrom is changed , however the dateto is NOT

if we do NOT select the template, it is OK.
But I have to save a template to run on schedule.


If I change the dateto from [WeekEnd]-1   to

DateTo  =DateAdd( ([@WeekStart]-1), 'd', 6)

I can work around on this issue.

NOTE: after you change the rpx, you have to resave the template.


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 — 2020  Acumatica, Inc. All rights reserved