Comparatives date formula

spnav

I am trying to create date filters based on the current and the equivalent previous financial year (ie. 0101..3112) without mentioning the year in the formula. I am using the CALCDATE function but I cannot get a value for 01/01 and its equivalent for the previous year. Can anyone help?

DaveT

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.

spnav

Can you show me an example ?

DaveT

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 );