Text only
|
Text with Images
COGNOiSe.com - The IBM Cognos Community
IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Todd129 on 20 Dec 2012 08:17:14 PM
Title:
Cast external data
Post by:
Todd129
on
20 Dec 2012 08:17:14 PM
Hello
I am importing external data with date format yyyymmdd that is an integer.
How do I cast this integer as a date after import?
Many thanks!
Title:
Re: Cast external data
Post by:
blom0344
on
21 Dec 2012 02:21:54 AM
cast ([YearMonthDay];date) where [YearMonthDay] is in the YYYYMMDD format
Text only
|
Text with Images