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: 
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