Issue using dates with PDOField

131 Posts

lancipoos Reply #1, 10 years, 2 months ago

Can't seem to work this one out ... I'm trying to pull the *publishedon and *unpub_date tvs from one resource to display on another.

[[pdoField?
    &id=`15`
    &field=`publishedon`

So in this example pulling resource no. 15's date to display on the page in question. Currently it displays the timestamp and not the date.

Using a page's tv directly I'd use strtotime:

[[*publishedon:strtotime:date=`%Y-%m-%d`]]

as an output modifier. With PDOField I've tried various syntax for this with no success.

This question has been answered by Bruno17. See the first response.

discuss.answer

5,888 Posts

Bruno17 Reply #2, 10 years, 2 months ago

did you try

[[pdoField:strtotime:date=`%Y-%m-%d`?
    &id=`15`
    &field=`publishedon`
]]

maybe, you don't need strtotime, if you get the unixtime allready.

-------------------------------

you can buy me a beer, if you like MIGX

http://webcmsolutions.de/migx.html

Thanks!

131 Posts

lancipoos Reply #3, 10 years, 2 months ago

Thanks Bruno.
Without that, I'm getting an output of 1470760080. With the strtotime added from your quote above, PDOField returns blank

131 Posts

lancipoos Reply #4, 10 years, 2 months ago

Ah, I get what you mean.

[[pdoField:date=`%Y-%m-%d`?
    &id=`15`
    &field=`publishedon`
]]

This works perfectly. Thanks.

24,544 Posts

BobRay Reply #5, 10 years, 2 months ago

I discussed this here: http://bobsguides.com/blog.html/2013/09/18/displaying-modx-date-fields/.

It looks like pdoField returns the raw value of the date field, which is a unix timestamp. It's a nice alternative to the double conversion usually performed.

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

Answered Issue using dates with PDOField