Self Registration - Date showing as unreadble numbers only

[sing2trees]

Hi,

I have a date of birth field in the self-registration module.

When a user signs up, they enter their date of birth, however whenever I export the data (from the Admin section of Frontend User Management), the date of birth only shows as numbers.

Ie:
17th February 1983 exports as:
414288000

Does anyone know how I can fix this?

Thanks in advance!

[jmcgin51]

The stored value is a Unix timestamp.  You need a script to convert it to a m/d/y format.

http://www.onlineconversion.com/unix_time.htm
http://www.unixtimestamp.com/index.php

[calguy1000]

use the cms_date_format smarty modifier that is included with CMS Made Simple.

[sing2trees]

use the cms_date_format smarty modifier that is included with CMS Made Simple.

Hi - where abouts do I find this?

Thanks in advance!

[jmcgin51]

something like this

{$yourdatetimevariable|cms_date_format} //will output the default date/time as you specified in the admin panel (Global Settings > General Settings)

or
{$yourdatetimevariable|cms_date_format:"%d-%m-%Y"} //will output the date/time in the format specified in the tag

http://php.net/strftime

[sing2trees]

The way I set this up was using the self registration module - so where would I add the code to convert it?

Sorry for all the questions - I really appreciate everyones help

[Jeff]

This is an issue with the Export function in FEU not in the Self Registration module.

[jmcgin51]

It sounds like you want the FEU export feature to export the date in a "human-readable" format.  You can submit a feature request for FEU in the Forge.

Until that feature is implemented, you will need to run a formula on that CSV field (after the export is complete) to convert Unix to time/date.

Here is a link to get you started:
spreadsheetpage.com/index.php/tip/converting_unix_timestamps/