Skip to Content
0
Former Member
Jan 14, 2008 at 04:38 PM

Unix Timestamp & Formula

304 Views

Post Author: eskimo42

CA Forum: Formula

I have an ecommerce DB which I am trying to report on using Crystal

Reports 2008. Please bear with me, this is my first time using Crystal

Reports. Here is my issue: The

order creation date field in the eCommerce DB is being pulled as a Unix

Timestamp. After some research online I have found that this formula

should help me convert the timestamps into a readable format:DateAdd (u201Dsu201D,{jos_vm_orders1.cdate}-18000, #1/1/1970#)So

I have created numerous formula fields, Formatting Formulas, Custom

Functions, and all I can seem to come up with is this error:The ) is missing. I

really hope someone can walk me through how exactly I can convert a DB

field which appears in a report to, a readable time stamp with that

formula I have above. Thanks,Evan