Comparatives date formula

Comments

• DaveT Member Posts: 1,039

  2008-08-30

  Hi,
  
  The normal way is to use the virtual table date or the accounting period table depending on the context. These will give to the period starts and ends.

  Dave Treanor
  
  Dynamics Nav Add-ons
  http://www.simplydynamics.ie/Addons.html

  0
• spnav Member Posts: 7

  2008-08-30

  Can you show me an example ?

  0
• DaveT Member Posts: 1,039

  2008-08-30

  Hi Spnav,
  
  Declare a variable of datatype record, subtype date/accounting period. Then in the onprereport use

  DateVar.setrange( "period type", "period type"::year );
  DateVar.setrange( "period no.", date2dmy( workdate, 3 ) -1 ); // get last year
  datevar.find( '-' );
  startdate := datevar."period start";
  datevar.next;
  enddate := datevar."period end";
  
  

  
  In the on predataitem use a setrange( "posting date", startdate, enddate );

  Dave Treanor
  
  Dynamics Nav Add-ons
  http://www.simplydynamics.ie/Addons.html

  0