Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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