Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Date Format

Hi All,

The date field in my model starts well on the Raw-data section (01/09/2013 14:10:00), but in the Dw it goes out of format and looks like that:41518.590277778.

is there a magic spell to keep it in date format?

thanks

avner

1 Solution

Accepted Solutions
albertovarela
Partner - Specialist
Partner - Specialist

Try:  timestamp(yourfield, 'MM/DD/YYYY hh:mm:ss')

View solution in original post

2 Replies
albertovarela
Partner - Specialist
Partner - Specialist

Try:  timestamp(yourfield, 'MM/DD/YYYY hh:mm:ss')

Anonymous
Not applicable
Author

works perfect,

thanks