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