# how to fetch last one month transactions in x++ ?

**URL:** <https://www.dynamicsuser.net/t/how-to-fetch-last-one-month-transactions-in-x/59949>\
**Category:** Developer Forum\
**Created:** [February 22, 2016, 7:04pm UTC](https://www.dynamicsuser.net/t/how-to-fetch-last-one-month-transactions-in-x/59949 "2016-02-22T19:04:41Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![sreedhardax](https://avatars.discourse-cdn.com/v4/letter/s/848f3c/32.png) [@sreedhardax](https://www.dynamicsuser.net/u/sreedhardax)\
**Post date:** [February 22, 2016, 7:04pm UTC](https://www.dynamicsuser.net/t/how-to-fetch-last-one-month-transactions-in-x/59949/1 "2016-02-22T19:04:41Z")

</div>

any one reply me

---

<div class="post-metadata">

**Author:** ![kranthi](https://avatars.discourse-cdn.com/v4/letter/k/e480ec/32.png) [@kranthi](https://www.dynamicsuser.net/u/kranthi)\
**Post date:** [February 23, 2016, 5:21am UTC](https://www.dynamicsuser.net/t/how-to-fetch-last-one-month-transactions-in-x/59949/2 "2016-02-23T05:21:02Z")

</div>

what transactions you are talking about? Do you have a date on the transactions?

please elaborate.

---

<div class="post-metadata">

**Author:** ![Rajendra\_Chilukuri](https://avatars.discourse-cdn.com/v4/letter/r/7ba0ec/32.png) [@Rajendra\_Chilukuri](https://www.dynamicsuser.net/u/Rajendra_Chilukuri)\
**Post date:** [February 23, 2016, 5:22am UTC](https://www.dynamicsuser.net/t/how-to-fetch-last-one-month-transactions-in-x/59949/3 "2016-02-23T05:22:13Z")

</div>

CustTrans custTrans;

date todate = today();

date fromdate = prevMth(today());

while select custTrans where (custTrans.TransDate \>= fromdate && custTrans.TransDate \<= todate) && custTrans.AccountNum ==‘DE-001’

{

info(strFmt("%1",custTrans.AmountMST));

}

Hope this may helps you!!!
