Date a transaction was entered into the register

tesar861's Avatar


27 Jun, 2022 10:01 PM

the "DATE" column can be any date of my choosing (03/02/2031) but a "SHOW TRANSACTION DETAILS" gives this info. how does one decipher the date entered? I entered this today 06/28/2022.

0.acctid: e3390f45-0558-4edc-ba15-3584d45375a1
0.desc: cc tampa (april) 233.98 62f97480-ab84-4593-9d48-75a178573d0a
0.oldid: -1
0.pamt: 23398
0.samt: -23398
acctid: af6f65e6-d905-4062-9182-ca9630bdbf9e
desc: cc tampa (april) 233.98
dt: 20310302
dtentered: 1649072544930
id: f972441a-d9d4-4de0-8d5e-f08ce8537e66
obj_type: txn
oldid: -1
td: 20310302
ts: 1649248977279

  1. 1 Posted by tgilbert666 on 28 Jun, 2022 12:22 AM

    tgilbert666's Avatar

    MD stores an Unix epoch date. You can research it on Google or convert it by plugging it here amongst other places.

    Tony - fellow user

  2. 2 Posted by tgilbert666 on 28 Jun, 2022 12:57 AM

    tgilbert666's Avatar

    PS - How sure are you that you entered this transaction on Jun 28? It appears to have been entered in early April and updated a few days later?

  3. 3 Posted by tgilbert666 on 28 Jun, 2022 01:03 AM

    tgilbert666's Avatar
  4. 4 Posted by Stuart Beesley ... on 28 Jun, 2022 04:40 AM

    Stuart Beesley (Mr Toolbox)'s Avatar

    Toolbox extension, general tools, has an option to decide dates. Just enter ‘ 1649248977279’ for example and it will tell you the human readable version.

  5. 5 Posted by tesar861 on 28 Jun, 2022 11:56 AM

    tesar861's Avatar

    Why not have MD convert the date and also display that info when requested?

    Also have an option to add the date entered column to a register display.

    Enhancement/user option for display on/off

    Dean Tesar

    On Jun 27, 2022, at 9:04 PM, tgilbert666 <[email blocked]> wrote:


  6. 6 Posted by tesar861 on 28 Jun, 2022 11:58 AM

    tesar861's Avatar

    Ill look at this next chance I get.

    But why not have MD convert it without the extra steps?

    Dean Tesar


    On Jun 28, 2022, at 12:40 AM, Stuart Beesley (Mr Toolbox) <[email blocked]> wrote:


  7. 7 Posted by dtd on 28 Jun, 2022 08:27 PM

    dtd's Avatar

    just a user

    Transaction details are just that - details of what was actually recorded. Once you begin changing that set of detail entry, you make it harder to see what was actually entered into the database.

    I think what you might be asking for is to expose the "transaction entry date" (converted into a normal date).

  8. 8 Posted by tesar861 on 28 Jun, 2022 08:34 PM

    tesar861's Avatar

    Ok expose the date as something more useful.

    Dean Tesar

    On Jun 28, 2022, at 4:27 PM, dtd <[email blocked]> wrote:


  9. System closed this discussion on 27 Sep, 2022 08:40 PM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts


? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac