How to strip my date field which is in this format (DD/MM/YYYY hh-mm-ss AM/PM) into something like this (DD/MM/YYYY) and basically get rid of the time part?

[rt_new_user]

[oknotsen · Accepted solution]

Floor it.

When loading the timestamp, use the floor() function to remove the time part.

Floor(someDate) as someDate,

If it still shows with the time as part of it, add the date() function.

[rt_new_user]

Thanks it worked!!