With Acumatica You Can Gather Data by Specified Date - ERP Cloud Software
 
ERP Software Logo

ERP Cloud experts provide comparisons and opinions to professionals in the ERP software selection process

 

Crestwood Associates

With Acumatica You Can Gather Data by Specified Date


Email | Print

When searching your records and compiling data, it often happens that the information you need must be pertaining to defined dates or ranges. Perhaps you want to view licenses which will expire any time in the next month or two, or perhaps you need to know what incoming shipments are due in the next few days.

Acumatica allows you to find that date specific information by formulating DateAdd (date, interval, number) to retrieve the data related to predefined calendar blocks.  This formula generates a new computed date by adding a pre determined number of years, months, weeks or days to the current date.

Let’s say you want to compile a record of all incoming orders expected now or within the following week and a half using the formula:  =DateAdd(today(),’d’, 9)

This formula permits the use of dynamics values rather than using parameters specifying designations such as Date1 is Greater than and Date2 is Less than.

Here is a complete syntax of the formula:

The formula will calculate a time period by combining the specific number (nbr) of time intervals (int) with the date (dt). The int argument allows you to select the interval.  It should be one of these choices:

  • y - A number (nbr) of years will be added to the defined date (dt).
  • q - A (nbr) of quarters will be added to the defined date (dt).
  • m - A (nbr) of months will be added to the defined date (dt).
  • y - Same as d; see below.
  • d - A (nbr) of days will be added to the defined date (dt).
  • w - A (nbr) of weekdays will be added to the defined date (dt).
  • ww - A (nbr) of weeks will be added to the defined date (dt).
  • h - A (nbr) of hours will be added to the defined date (dt).
  • n - A (nbr) of minutes will be added to the defined date (dt).
  • s - A (nbr) of seconds will be added to the defined date (dt).

Here are some samples:

DateAdd($DueDate, 'm', -2)

DateAdd(CDate('31/01/1995'), 'm', -2)

DateAdd($DueDate,'y', -2)

DateAdd(Cdate($DueDate), 'd', -2)

Observe that in some of the cited instances, DueDate ($DueDate) is a report variable.

To learn more about Acumatica, contact Crestwood Associates

by Crestwood Associates

 

 

 

Ask This Expert a Question / Leave a Comment