Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

convert timestamp to string

Hi

I have 2 columns  datatext(datatype varchar2) and date_created(timestamp)

the sample data for the columns

datatext  - apr-23-2011

date_created - 4/23/2011 1:56:19 PM

Now i want convert date_created format to datatext  ..

How do i do that ?

Please Help...

2 Replies
Not applicable
Author

i think something like this could help you

= left(monthname(date_created),3) &'-'&day(date_created)&'-'&year(date_created)

Anonymous
Not applicable
Author

What about this:

= Text(Date(Date#([date_created]), 'MMM-DD-YYYY'))