We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 26367
    • 14 Posts
    Can I use the "date" Template Variable to call/edit a documents "createdon" date?

    If so how does one go about doing that?

    Thanks
      • 26367
      • 14 Posts
      Have I asked this question in the wrong section?

      Thank you, Jeremy
        • 4310
        • 2,310 Posts
        The createdon field is stored in the main site_content table in the DB.
        There is no direct way of editing it from the Manager that I’m aware of.
        You could do it via phpMyAdmin, but it’s stored as a unix timestamp e.g. 1144904400, so is a little tricky to edit.
        Why do you want to edit it?
          • 26367
          • 14 Posts
          Thank you,

          I have been manually editing the entry in phpMyAdmin already but that will not work for our clients.

          The main reason is that I could not get the reflect/wordpress snippet to function at all using "pub_date".

            • 3749
            • 24,544 Posts
            Try publishedon instead of pub_date. The pub_date field is empty unless you set a future publication date. The publishedon field should hold the date when the doc last changed from unpublished to published. For new documents, it should be set equal to createdon.
              Did I help you? Buy me a beer
              Get my Book: MODX:The Official Guide
              MODX info for everyone: http://bobsguides.com/modx.html
              My MODX Extras
              Bob's Guides is now hosted at A2 MODX Hosting

            This discussion is closed to further replies. Keep calm and carry on.