group by month, quarter, year

beesakayawongbeesakayawong Member Posts: 3
edited 2010-12-13 in Navision Attain
Dear All,

I'm new for NAV. and my project is to group field "amount" in "Purch. Inv. Header" classify by field "currency code" group by year, quarter, and month. pls help me
Thank you very much.

Comments

  • ShedmanShedman Member Posts: 194
    Check out the DATE2DMY and DATE2DWY functions.
  • beesakayawongbeesakayawong Member Posts: 3
    I used function DATE2DMY to seperate year,month, but I can't group it. :cry:
Sign In or Register to comment.