Hi - in INV parameters we have the Period Length for Item history as 4 Weeks. Has anyone out there already created some code for this that is you have a date you can get the period for it according to this 4 week period parameter? I'm modifying the Item Issue by Period report to add a column for delivered qty. I was going to go to the Purchase order lines table and get the dqua field but I need to total the qty by that period and I have just date to go by.

Any thoughts??

NikkiZ

You can search on this forum for num.to.date$() with the date number its possible to calculate de 30 days(4 weeks) u talked...

I don't know on Bann IV but in LN we have the session tccorl200m00l wich use the funcion utc.num() to convert and compare dates.

Refers to the files i Up

hope it helps

Thanks for the exe file it helps me out. Thank you.