Datetime to date as custom measure


Hi, I have been trying to create a custom measure that just gets the date as yyyy-mm-dd from the date column (the column contains HHHH:MM:SS too. Is it possible? what’d be the syntax for this as custom measure?


Hi @dfernan,

date_trunc(day, time_field) should work. If you want you can cast that to a date with cast(date_trunc(day, time_field) as date). In Immerse though it looks like its still interpreting it as a timestamp (showing the trailing HH:MM:SS). Were you hoping to show it just as say “May 17, 2017”?


Hi darwin, Thanks. yes that’s what I was hoping for but you are right it still show a timestamp… never thought this was a tricky Q…