get records by selected month

(0) Share

Report

Posted on by SII1MNL

1,295

Hi,

I would like to know how to get the records by month from 1st day to last day of the month only (for example in inventtrans I want to get the records based from date Financial,

can you please give me some ways how to get it? because I already created one (i choose June but its getting all the data from june till december of this year)

my code:

while select forupdate inventTrans where closingsumdateselected <= inventTrans.DateFinancial && inventTrans.DateFinancial >= closingsumdateselected

hoping for your prompt response. thank you

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (1)

Verified answer

SII1MNL 1,295 on at

Like (0)

Report

RE: get records by selected month

I found the solution already. I used endmth method to get the end of the month. Thank you for your help. :)

Was this reply helpful? Yes No
SII1MNL 1,295 on at

Like (0)

Report

RE: get records by selected month

because on the form is only month and year no specific from date - to date. when I select june and calculate starting from june 1-30.

Was this reply helpful? Yes No
Suggested answer

Mea_ 60,284 on at

Like (1)

Report

RE: get records by selected month

You want to show on this form records only from current month ?

If yes you need to add range on a query.

You can override init method of the form and do something like:

element.query().dataSourceTable(tableNum(MyTable)).addRange(fieldnum(MyTable, MyDate)).value(SysQUery::range(fromDate, toDate));

Was this reply helpful? Yes No
SII1MNL 1,295 on at

Like (0)

Report

RE: get records by selected month

how to get records based from month? the form I created above is only by month so meaning July1-31 only. Do I need to use datefrom,dateto?

Was this reply helpful? Yes No
Mea_ 60,284 on at

Like (0)

Report

RE: get records by selected month

And what is the question ?

Was this reply helpful? Yes No
SII1MNL 1,295 on at

Like (0)

Report

RE: get records by selected month

Hi,

I created this form the calculation will be based from month only (July1- July30).

Was this reply helpful? Yes No
Ali Zaidi 4,655 on at

Like (0)

Report

RE: get records by selected month

Hi Ivan, you have to create two utcDatetime and then query on InventTrans

following code snippet possible helps you to solve your problem

startdate =mkdate(Day_number, Month_number, Years_Number);

EndDate =mkdate(Day_number, Month_number, Years_Number);

_UtcStartPeriod = DateTimeUtil::newDateTime(startdate,0);

_UtcEndPeriod = DateTimeUtil::newDateTime(EndDate,86400);

while select * from inventTrans where inventTrans.DateFinancial > _UtcStartPeriod && inventTrans.DateFinancial <= _UtcEndPeriod

Was this reply helpful? Yes No