Datetime to Date format using Data Manager

[klrameet]

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 ?

[PriyankaShivhare]

use floor function
floor(ur datetime field)
Thanks,
Priyanka

[klrameet]

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.