Is it possible to combine two meta items and concatenate them into a third? - Meta Box

This topic has 3 replies, 2 voices, and was last updated 9 years ago by Anh Tran.

Viewing 4 posts - 1 through 4 (of 4 total)

Author

Posts
November 6, 2015 at 1:55 AM #1691

jonwatson87
Participant

I'm trying to do a query based on TWO meta values which I need to combine in order to perform a comparison.

Essentially, I'm trying to join a date and a time field to return the exact datetime that an event ends and compare it to the current datetime.

Is such a thing possible? Can I combine a date meta and time meta in order to get a datetime meta? Or would it just be easier to remove the end time field, replace it with a datetime field and go back through my posts to change the data?

Add New Note to this Reply

November 9, 2015 at 9:24 AM #1704

Anh Tran
Keymaster

Hi,

Sorry for this late reply. I think it's possible if you want to combine 2 values only when querying the database using raw MySQL query. But if you want to combine them in another way or somehow (I'm not sure what you want exactly), then maybe you need to write a custom script to check and re-add a new meta value for each post.

Add New Note to this Reply

November 13, 2015 at 3:31 AM #1727

jonwatson87
Participant

Thanks, Ahn! I did have a look at doing it that way, but in the end it was quicker and easier just to go back and change all the date and time fields to combined datetime ones!

Thanks for the suggestion, and for getting back to me! 🙂

Add New Note to this Reply

November 13, 2015 at 10:23 AM #1729

Anh Tran
Keymaster

Great that you have resolved this 🙂

Add New Note to this Reply
Author

Posts

Viewing 4 posts - 1 through 4 (of 4 total)

The topic ‘Is it possible to combine two meta items and concatenate them into a third?’ is closed to new replies.