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: 
klrameet
Contributor III
Contributor III

Datetime to Date format using Data Manager

How do i force this column to display date into DD/MM/YYYY format ?

I tried selecting input format as DD/MM/YYYY hh:mm:ss[.fff] TT & output as DD/MM/YYYY  but no luck, what am I missing here ?

T.PNG

Labels (1)
2 Replies
PriyankaShivhare
Creator II
Creator II

use floor function
floor(ur datetime field)
Thanks,
Priyanka
klrameet
Contributor III
Contributor III
Author

Hi @PriyankaShivhare 

I am able to manipulate it on charts using floor/trim but i am rather interested in handling it while loading the data using data manager and have it loaded as MDY.