Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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

Labels (1)
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