Posting Date

siyaksiyak Member Posts: 66
Hello Pips!!!please help
I'm running a report and i have filted posting date,so i need to see the Start and End dates on the report.please help ](*,)

Comments

  • Stardust77Stardust77 Member Posts: 95
    You can define two variables StartDate and EndDate and then use:
    StartDate := GETRANGEMIN("Posting Date");
    EndDate := GETRANGEMAX("Posting Date");
    
  • siyaksiyak Member Posts: 66
    That was the one i used and it was complaining that i must enter the posting date that is on the G/l Entry
  • Stardust77Stardust77 Member Posts: 95
    You should put these in the OnPreDataItem of the G/L Entry DataItem, or if you put them somewhere else (i.e. in the OnPreReport trigger) you should use:
    StartDate := "G/L Entry".GETRANGEMIN("Posting Date"); 
    EndDate   := "G/L Entry".GETRANGEMAX("Posting Date");
    
  • siyaksiyak Member Posts: 66
    Ok Thanks i have discovered that i putted the code in the wrong data item table.Sorry guyz i got correct and thanks!!
Sign In or Register to comment.