Date a transaction was entered into the register

tesar861's Avatar

tesar861

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
0.id: 62f97480-ab84-4593-9d48-75a178573d0a
0.obj_type:
0.oldid: -1
0.pamt: 23398
0.samt: -23398
0.tags:
acctid: af6f65e6-d905-4062-9182-ca9630bdbf9e
chk:
desc: cc tampa (april) 233.98
dt: 20310302
dtentered: 1649072544930
id: f972441a-d9d4-4de0-8d5e-f08ce8537e66
memo:
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
    https://www.epochconverter.com/ amongst other places.

    Cheers
    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
    706.502.4041

    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

    706.502.4041

    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.
    Thanks

    Dean Tesar
    706.502.4041

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

    

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:

»

Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

Keyboard shortcuts

Generic

? 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