Reading a custom field with a date

[amecca]

I am trying to read a custom field with a date in it, like "12/3/2012". I would like to determine if today is before or after that date. Is there a way to do that?

[Kent Multer]

Re: Reading a custom field with a date

If you have Toolkit or Toolbelt, you can write a series of tags that will split the date into three separate numbers, so that you can compare them using mvt:if tags. If you tell us a little more about what you're trying to do, there may be other ideas.

[amecca]

Re: Reading a custom field with a date

I have both tookit and toolbelt. Here is what I would like to do. Our products have different Christmas deadline dates. SO for one product the deadline may be 12/12/2012. I can import this date into a custom field. Then I would like to read that field to determine what note I should show on the category or product page. If today's date is after the deadline it would say "This product is past the deadline to be received by Christmas" if before it would say "This product is still available for Christmas delivery".

[Kent Multer]

Re: Reading a custom field with a date

Displaying messages like that should definitely be do'able, but I can't give you all the code off the top of my head. If you'd like to have me do a little custom editing on your page templates, you can contact me by email to discuss it. Or maybe there's a power user reading this who can give you some code to copy and paste.

Hope you have a great season :^) --

[Bruce - PhosphorMedia]

Re: Reading a custom field with a date

Use Unix time. (http://www.onlineconversion.com/unix_time.htm)

Then simply use:

<mvt:if expr="s.time_t LT l.settings:product:customfield_values:customfields:ShipTime">
It can ship
<mvt:else>
Sorry, too late
</mvt:if>