how to trim off time from date

[skyline01]

I have a date-time field with values like:

1/1/2018 0:46

10/31/2018 18:00

I need to trim off the timestamp from the date.  So, I used the usual technique: floor(date(field)).  However, I get nulls returning (i.e., it doesn't trim properly).  In fact, when I just use floor(field), I still get nulls.  So, something is wrong with the floor function on my field.  How do I resolve this?

[pradosh_thakur]

If your field is a timestamp then floor(field) will do
if is in string format then floor(timestamp(timestamp#(field,'MM/DD/YYYY hh:mm'))) will work.

[pradosh_thakur · Accepted solution]

You might need to add a date function before floor to get it in required format

or
DATE(date#(subfield(field,' ',1),'MM/DD/YYYY'))