Time on Date

[Anonymous]

Hi, im sure this is a simple fix but didnt want to waste a couple of hours trying to figure it out.  i have a table that shows dates, but the table it brings it from includes times as well.... how do i lose the times? (the imported table comes from a Syspro live database)

see attached

[jvishnuram]

Hi James,

Use the Date() function.

Date(Your_Field,'DD-MMM-YYYY')

[giakoum]

or floor it to eliminate time

[manojkulkarni · Accepted solution]

use Date(datefield,'DD-MM-YYYY')

[#5]

hi

try this

Date(date#(datefieldname,'DD/MM/YYYY hh:mm:ss'),'DD-MM-YYYY')

******************************************************

DATE(FLOOR(DATEFIELDNAME))

[giakoum]

Manoj K :

how is that different from Vishnu Ram reply?

[Anonymous]

Great, thanks everyone

[manojkulkarni]

both are same, by the time replying screen was yet to refresh i believe.