Change Time to Date

I have added the “Wp S2m Auto Eot Time” field to my Users – Report for Email. But I would much rather have that field populated from “Wp S2m Auto Eot Date.” Is there a relatively simple way for me to change this?

Hi Rebecca,

Can you show us the code you added? If I can see that, I’ll have a better idea what you’re trying to do.

I’m sorry if I was not clear – I had not yet reached the point of manually changing code. I am using the S2members plugin in my WordPress Admin Area. Under users, a list called “Report for Email” had already been created. We want to add a column to the report that shows when their subscription expires. Using “Configure this list” I placed the new column from the list available, adding “Wp S2m Auto Eot Time.” But that field displays the data as a Unix Time Stamp. We really need a date readable in English human language. I have noticed that when exporting a full members list, the field “Wp S2m Auto Eot Date” is included – which is just what we want in the “Report for Email.” But that field name is not among the list displayed as available for configuring my email report. (I’m assuming since it exists in the database, it should be a fairly simple matter to include when configuring a new report.)

(By the way – this is necessary because the full members report export sends only csv files in bursts of 250 members at a time – a cumbersome process when one is dealing with thousands of members. This is an issue we have talked about before, and I was told a modification might be considered for this summer’s revise. Meanwhile, the custom Report for Emai is not liimited in that way. So – in part – this is a workaround to avoid the problem we wrote about earlier. FYI.)

I hope this is clearer than my initial query.

Hi Rebecca,

It sounds like you’re using a 3rd party plugin that generates the “Report for Email” and allows you to “add a column to the report”, as those are not features of s2Member.

The s2Member EOT time is stored in the database as a Unix Timestamp. If you wish for that plugin to display the data in another format, you’ll need to modify the 3rd party plugin to convert the Unix Timestamp into a human readable format before displaying it using the PHP date() function.