How do I convert a linux date to a y m d fabrik date.

[cmendla]

I am using nbill light which generates tables in the site database. One of those tables has invoice info.

I can easily make a copy of that table and link a fabrik list to it.

The problem I am running into is that the date of the invoice is stored in a linux format which is the number of seconds since 1/1/1970. Therefore 2/28/15 looks like 1425081600.

I set up another element in the data table called date converted with the following settings

• Date plugin
• Default set to echo date('Y-m-d', rpot1_nbill_document_copy___document_date);
• Eval = "Yes"
• Advanced formats = ''yes'
• Allow date function/PHP Allow date function are blank

The document date shows in the list but the converted date is blank.

I'd appreciate any help with what formula to use and where to put it.

Unfortunately I can't post a public link as it has invoicing info. I could provide it to the publishers if necessary.

thanks

chris

 

[troester]

Default settings are run only if a new record is created (BTW: it must be return, not echo and placeholders must be included in {})

I can easily make a copy of that table and link a fabrik list to it.

You could create a date column while copying.

If you only want to display the date you can use the timestamp element.