Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am trying to remove the timestamp on a date field. The date values are formatted as 2017-02-23T00:00:00.
I tried the following functions to remove the timestamp but, they all did not work.
Does anyone have suggestions as to how I can remove the timestamp?
Thank you in advance for any assistance!
FLOOR(<datefield>) AS Date
You can format that field, in the UI, to MM/DD/YYYY. Or whatever format you need.
FLOOR(<datefield>) AS Date
You can format that field, in the UI, to MM/DD/YYYY. Or whatever format you need.
Thank you Michael!