Deleted transactions should be excluded from Last Used date query

[tactilis]

MMEX version:

• 1.6.2

See https://forum.moneymanagerex.org/viewtopic.php?p=23647

Deleted transactions are being included in the query to determine the 'Last Used' default date for new transactions.

Expected result

Only the transactions visible in the account should be used to determine the 'Last Used' default date for new transactions. Deleted transactions should be excluded.

[vomikan]

There is a problem. Only for newly created transactions, the DELETEDTIME field is empty. For previously created there null.

therefore, even if there is a transaction, its date is not taken into account.

[n-stein]

We ran into a similar issue before with the nulls. In the next DB update script perhaps we should set all the nulls to blanks and change tables.sql to specify the default for DELETEDTIME as blank. That way using DELETEDTIME(wxEmptyString) in a find_all will return all valid records.

[vomikan]

I wondered if this algorithm is correct?
It finds the maximum transaction date of the account, but less than or equal to today's date. It probably works well in most cases. But for those who start transactions for the future, it does not really help.
And the LASTUPDATEDTIME attribute also appeared. We can use it too.

We can make more options:

1. None
2. Last used
3. Maximum invoice date
4. Max. but less than today
5. Maximum per month