MMEX Discussion Forum

Hello everyone, I'm writing from Italy, forgive my bad English, I use google traslator: o) In the reports it is not possible to indicate a period of dates, from date to date, other than those proposed in the system, I wanted to know how you can enter a time period example: 01/01/2020 - 31/01/2020 thanks to all .

I'm assuming you are using v1.3.3

It's not possible in v1.3.3

It was to be a feature in v1.4.x which is still in development

I'm not sure if they've put that feature into v1.3.4 release that is now availabe.

I cannot see the feature in the 1.3.4 beta release I downloaded on 09MAR2020 and am currently using. However in the HELP notes for the General Report Manager in the 1.3.4 beta I see the sentence below which says that the feature is going to be in the 1.4 release.

For MMEX version 1.4.0 there is a possibility to transfer dates into a report's SQL script.There are six options available: &single_date, &begin_date, &end_date, &budget_years, &fin_year_day, &fin_year_month. In case if a SQL contains one of the parameter above it will be replaced with a date from a calendar widget or a value from the MMEX settings.

Hi, that is for General Report Writer for when writing your own reports in v1.4.x

This is one of the standard reports from v1.4.x - hopefully the developers will finish it off soon or pull the functionality into v1.3.4+

Thanks

Thanks

Thanks, that works! I was simulating a return on investment plan for some real estate in Cannes for my boss, and I had issues with the time periods as well...

In v1.3.4 it would be possible as well.

Hi Nikolay

Are you saying the parameters can be put into 1.3.4 custom reports as per 1.4.x ?

Is there a full list of the parameters?

I downloaded MMEX v1.3.4.rc.3 earlier today. I discovered that you can now set the time period in a number of custom reports. There is a new option called "Custom" listed after the "Last 365 Days" selection and once you select "Custom" the two date fields containing calendar widgets which were previously grayed out are no longer grayed out and allow you to set the time period to anything you like. This capability to specify "Custom" is added to all the custom reports (Categories, Payees, Income vs Expenses). This is a welcome addition which makes these custom reports twice as useful as they were before, Thanks to the MMEX developers for this fine addition to the product.

There is a sample sql in the help page with &single_date variable.