Looking for a second transaction date for report purpose.

Build and share your cool customized reports built w/ one sql, Chart.js and Lua (https://github.com/moneymanagerex/general-reports)

Moderator: Renato

Post Reply
Eduardommex
New MMEX User
Posts: 14
Joined: Sat Jun 26, 2021 2:40 pm
Are you a spam bot?: No

Looking for a second transaction date for report purpose.

Post by Eduardommex »

Hi
I would like to know if there is any field in any table where MMEx record the creation or update transaction date.
I am asking because I'm looking for a second field date for the cases the spend happens in a different day when it was created.
I know I can use a custom field or even a "number" transaction field to input this second date for report purpose but if there is any this will avoid me to enter it. I have checked in MMEx's tables that I found in GitHub, but it seems there is not this kind of field. Thanks
whall3y
MMEX Developer
Posts: 229
Joined: Fri Aug 21, 2020 5:44 pm
Are you a spam bot?: No

Re: Looking for a second transaction date for report purpose.

Post by whall3y »

No. We just hold the single date that is used to detail the date the transaction is posted to the account. Your only option is to use a custom field.
Nikolay
MMEX Developer
Posts: 1524
Joined: Sat Dec 06, 2008 2:27 pm
Are you a spam bot?: No
Location: Sankt-Petersburg, Russia

Re: Looking for a second transaction date for report purpose.

Post by Nikolay »

You can create an additional field of any type.
But it will only be a set of data that does not affect the business logic in any way. For example, the transfer will not be delayed when an additional date is specified. And when specifying the time, it will not affect the sorting of transactions.
Screenshot 2022-05-23 114447.png
Screenshot 2022-05-23 114447.png (16.26 KiB) Viewed 208 times
Post Reply