Often I get data with full time date stamps, really just the seconds since jan 1 1904. What I would like is a simple way to turn this into a date. Lump everything from midnight through 11:59PM.
Yes I can write a formula to do this but it would easier if
A. there was a Time format that would truncate this 01/26/2018 10:47 PM and 01/26/2018 4:13 AM to 01/26/2018 and model it as such. I can display it as a date, but it is modeled so they would be the same value.
B. An option from the equation builder to return the date. Yes I know I can write with a formula, but I think more than myself is doing this.