Hi all Mendix GURUs. I have this problem. I want to choose date (one day) and in next step i want to see some report. This report will shows data from monday to sunday always. I need to calculate which date is the select date and then shows rest of week. For example i choose 20.12.2012 and i want to calculate range 19.-25.12 and shows data for this range. Does anybody have some idea how to do it in Mendix?? Anythink will help. Regards, Lukas
What you need to now is what day of the week it is so you can retrieve the right range. With this function weekday from datetime
I think it would be possible to get the weekday. From there it is simple calculation to get the right range.