Filter Resources by date

Hey MODX people,

I'd like to filter the output of getResources by the current date. I have "event" as a template with "eventdate" as a TV.

I use the snippet "toDay" go get.. well: today


My getResources call contains this:


As these two formats are different, I dont know how to compare them. Its easy to display them in the same format, but in the tvFilters, I dont have this opportunity. Have I?

Its important for me that a 1pm event does not disappear at 2pm. So it's really "today".

Cheers,

Guido [ed. note: gallenkamp last edited this post 14 years ago.]

It seems like I have found something.

When I display different tv.eventdate, I get different formats:


and


That is why I always get too much resources. I imported about 800 resources from an evo site a time ago. Is it possible that the time format there is really different from the revo format of TVs type "date"? Thats no good...

Found a solution by editing the values via regex in notepad++ after exporting and replacing the database table. Will link to my blogpost here in a few minutes.

Here is what I did to get them all right:

http://bytethinker.com/blog/correct-date-format-with-notepad-and-regex