How to select data for Privious Week and for Next week in AX 2012?

(0) Share

Report

Posted on by Akshay Bankar

865

I develop a form, in that form 3 buttons are their----- PREVIOUS WEEK, CURRENT WEEK, NEXT WEEK. this are 3 buttons, If I click on PREVIOUS WEEK button then from Monday to saturday of last week data should come, same if I click on NEXT WEEK then from monday to saturday of next week data should come. same as for CURRENT WEEK, How can I write code for this??

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (0)

David Massey on at

Like (0)

Report

You are making the asumption that week starts on Monday. Not necessarily a good asumption. Portions of the application let you define the week start date. Timesheets is an example of the user being able to determine when the work week starts.

Use SysQueryRangeUtil::dateRange() with a combination of parameters like dateStartWeek(), dateEndWeek() to define the query range for the date field.

Was this reply helpful? Yes No
Viral Suthar 279 on at

Like (0)

Report

write a logic in button's click method

use following method to get start and end date of current week...

for start date

global::dateStartWk(systemdateget());

for end date

global::dateEndWk(systemdateget());

store that dates in two variable..

call the method which is fetch up your data....

and pass that values of variable as parameter in that method

use same logic to get last and next week dates and pass that value again in same method...

if still you have any doubt then reply me..

thank you

Was this reply helpful? Yes No
Akshay Bankar 865 on at

Like (0)

Report

Hi Viral.

Your code is working finely, but as per requirement I want to compaire dates from the AOS date.

Means,

in Organization administration-Area page-Common-Calendars-DateDimensions

here if I select the start day of week as Thursday then that button For previous week, next week and current week should work for that start day not from system date.

Was this reply helpful? Yes No
Viral Suthar 279 on at

Like (0)

Report

Hi,

Glad to have your reply akshay,

if i understood the sceanario then,

if start day of week is thursday &

today is monday = 24/9/2012

then current week is 20/9/2012 to 26/9/2012

last week is 13/9/2012 to 19/9/2012

next week is 27/9/2012 to 04/09/2012

am i right??

reply soon then i will give you the logic........

Was this reply helpful? Yes No
Akshay Bankar 865 on at

Like (0)

Report

Yes Exactly Viral,

Requirement is the same as you mentioned above.

Was this reply helpful? Yes No
Viral Suthar 279 on at

Like (0)

Report

some how i am not able to reply my logic dont know why can you give me your email id so i can share the logic with you.....

Was this reply helpful? Yes No
Akshay Bankar 865 on at

Like (0)

Report

Hi viral,

please send it on bankarakshay@gmail.com

Thanks Viral,

Was this reply helpful? Yes No

Community site session details

How to select data for Privious Week and for Next week in AX 2012?

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates

Community site session details

How to select data for Privious Week and for Next week in AX 2012?

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates