how can i get last mounth

(0) Share

Report

Posted on by mohammed.mqi

2,030

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

All responses (3)

Answers (1)

Aamir Shakeel 190 on at

Like (0)

Report

RE: how can i get last mounth

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
Suggested answer

nmaenpaa 101,156 on at

Like (2)

Report

RE: how can i get last mounth

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.
Verified answer

Satish Panwar 14,649 on at

Like (1)

Report

RE: how can i get last mounth

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.