Hi all, I was wondering why date & time fields are being stored as text instead of the datetime format. I'm trying to do some sorts & the fields not being converted to a timestamp makes it more difficult. Just curious if this was going to change, if there's a reasonable fix I can apply, etc.
Cheers!
The data is stored as a serialized array. They aren't stored in individual database columns which require a unique table be created for each form. Because the forms are dynamic, all the data is stored as a serialized array using the same database table structure.
ramseyp, the php function strtotime works like magic to convert nearly any time or date string into a Unix timestamp so you can use it in your sorts. Can you incorporate that into your code?
