Announcements
No record found.
how can i retrieve (select) lines from table which have last inserted in last month (i don't know the month which insert on it but i need last insert with month inserted in)
*This post is locked for comments
Hi Mohammed,
Please see link below, use prevmth and other functions to create date range and use them in select statement.
http://imdaxershiv.blogspot.com/2015/04/date-functions-in-ax-2012.html?m=1
Thanks,
Satish Panwar
Please take time to click yes against the answer that help guide you in right direction.
Obviously your table should also have some field that indicates when it's inserted. Without such field your requirement is impossible to fulfill. If you don't have such field, you can enable the CreatedDateTime property on the table. Then the creation datetime of a record is saved.
You can use the fiscal period to determine the last month transaction. Base on the current fiscal period you can determine last fiscal period date range and use that range to find out the records which were posted in that period. I
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Joris dG 5
Alexey Lekanov 2
Henrik Nordlöf 2 User Group Leader
