How to change Date and Time ?

[#1]

How to change the date & time format when given at the same time  like    (19-07-2017  03:31:50).

Any one can you please help to change these kind of formats.

[Kushal_Chawda]

Use floor function to convert it into Date form, floor will also remove repeating of dates in listbox

floor(YourDateField)

Make sure that your date is in Number format, else you need to use below expression

floor(Date#(YourDateField,'DD-MM-YYYY hh:mm:ss'))

[Anonymous]

Hi Mahendra,

Try the following Expression:

Date( Left ( Date# ( YourdateField ) ,5 ) , 'DD-MM-YYYY' )   AS   Date

Regards

Vinod Gadiputi