Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?