Hi,
Using CR7 with Impact/Encore 5.1 ODBC
Today I'm writing a bookings report.
When I pull a "transaction date" field from our DB, it produces date values in the following format:
20011012
20030707
20040205
However, my desired output is mm/dd/yy.
The data type for this field in CR is "number", not "date", so I'm not presented with the "DATE" tab in the Format menu.
Do I need to use a formula to convert the above format to mm/dd/yy? If so, can anyone offer help?
Thanks in advance - RRR
Using CR7 with Impact/Encore 5.1 ODBC
Today I'm writing a bookings report.
When I pull a "transaction date" field from our DB, it produces date values in the following format:
20011012
20030707
20040205
However, my desired output is mm/dd/yy.
The data type for this field in CR is "number", not "date", so I'm not presented with the "DATE" tab in the Format menu.
Do I need to use a formula to convert the above format to mm/dd/yy? If so, can anyone offer help?
Thanks in advance - RRR