topic Re: how to trim off time from date in App Development

how to trim off time from date

skyline01 — Sat, 16 Nov 2024 21:30:11 GMT

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?

Re: how to trim off time from date

pradosh_thakur — Wed, 30 Jan 2019 19:48:55 GMT

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.

Re: how to trim off time from date

pradosh_thakur — Wed, 30 Jan 2019 19:53:33 GMT

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'))