Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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.