cmendla
Member
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
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
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
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