Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey,
I'm trying to get rid of the time in a timestamp in the load script, and just have it show the date. I'm aware of functions like date(), but it only seems to change the formatting, not the underlying data. It will still, for example, show the whole DateTime, including "12:00:00 AM", in the Current Selection Box, even though I have a date()-function around my field in the load script. I've also tried the date(floor(field))-combination.
Any ideas?
How about you use like this?
Date(datefield,'M/D/YYYY')
or
Please see image, it in the number presentation of date in the object.
Try this
date(floor(num(field)))
Or date(daystart(Timestamp)). Here, daystart() is doing exactly what floor() does, but it's using a date and time function instead of a mathematical function, so it seems more consistent and correct to me. Honestly, I usually use floor(), but I feel like I SHOULD be using daystart() for consistency.