Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Date Format manipulation
- Thread starter chardt
- Start date
Hi,
I think (although there may be different ways) you could substring the column and create the date manually (Non Standard Date). Do something like this
Year - substring ( "Text Date" , 21 , 4 )
Month - substring ( "Text Date" , 5 , 3 )
Day - substring ( "Text Date" , 1 , 3 )
Hour etc
and create the dimension like an non date dimension.
However, you will not get the categories that come with creating the date dimension as a Regular Time dimension.
canhe
I think (although there may be different ways) you could substring the column and create the date manually (Non Standard Date). Do something like this
Year - substring ( "Text Date" , 21 , 4 )
Month - substring ( "Text Date" , 5 , 3 )
Day - substring ( "Text Date" , 1 , 3 )
Hour etc
and create the dimension like an non date dimension.
However, you will not get the categories that come with creating the date dimension as a Regular Time dimension.
canhe
- Status
Similar threads
- Locked
- Question