Date output modifier not working?

Trying to format a date, it isnot working:



It will always returns "Thursday January 1 1970" and an epoch formatted time... both columns in the database are date and time types, if I remove the formatting from the output, I get the correct date & time but wrong format...

What is the problem here?

[Revo 2.2.2 linux]

Try converting to epoch time first, then using the date output modifier:



You could also do this with just one field, but presumably you have reasons to want them separate. [ed. note: esnyder last edited this post 14 years, 5 months ago.]

Yes - I've tried converting an epoch date as well... no luck. still just returns the epoch year!

here's something funny, I just tried:
, it returns: "Thursday January 1 1970" as well!!

something is screwy. [ed. note: sean69 last edited this post 14 years, 5 months ago.]

That's odd -- I just tested the code I posted and it works for me. I edited the post to get the time format correct, I had it completely wrong the first time.

Maybe verify that just converting to epoch time actually works, that is, look at the output of

And verify that is correct.

Did you try the exact code I posted? You need to put the strtotime modifier first, before the date modifier.

No I didn't initially, I had changed the dates in the database to epoch times & changed the column type...

Your EXACT code DOES work however.. Thanks!

I don't remember ever having to do that before and the docs on output modifiers certainly don't reflect that unless you follow the 'Date Formats' link, the example they give is wrong here: http://rtfm.modx.com/display/revolution20/Input+and+Output+Filters+(Output+Modifiers)

Yeah, that always seemed odd to me too -- that you have to apply another filter first in order for the date filter to work. It would be better if the date filter would check if the date is in epoch format, and convert it if it is not, that way this code would still work, and the date filter would work on its own.

Glad you got it working!

ha.. yea, it would be best if it were documented better

I find it really strange that if I give the date =`` modifier an epoch formatted date to start with, that it still chokes... must be a bug of some sort.

oh well, it works now.

I think the reason that's necessary is that whatever you're using to set the placeholders (getResources?) converts the date placeholders to a time string, so if you're going to do your own formatting, you need to convert them back to unix timestamps with :strtotime. If your placeholder contained a raw unix timestamp, your original code would work.


------------------------------------------------------------------------------------------
PLEASE, PLEASE specify the version of MODX you are using.
MODX info for everyone: http://bobsguides.com/modx.html

Not sure where/if it is getting reformatted? All I am doing is pulling the values from a custom table & outputting to a chunk: